Adel Abu Hashim & Mahmoud Nagy - August 2021
This case study aims to help Amber Heard
By analyzing new accounts posting/ commenting against a victim of a Social Bot Disinformation/Influence Operation.
We have three main datasets:
(The datasets screaped from reddit).
- 1- A dataset with submissions & comments data (2020).
- 2- Users Data (from 2006 to 2020).
- 3- A merged dataset (submissions & comments data, users data).
- 4- Daily creation data (# of accounts created per day from 2006 to 2020)
#import dependencies
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sb
import helpers
import matplotlib.dates as mdates
import plotly.express as px
import plotly.graph_objects as go
import re
import warnings
import datetime
warnings.filterwarnings('ignore')
sb.set_style("darkgrid")
%matplotlib inline
# load data
df = pd.read_csv("cleaned_data/reddit_cleaned_2020.csv")
df_merged = pd.read_csv("cleaned_data/reddit_merged_2020.csv")
df_users = pd.read_csv("cleaned_data/users_cleaned.csv")
df_users['user_created_at'] = pd.to_datetime(df_users['user_created_at'], format='%Y-%m-%d %H:%M:%S')
df_users = df_users[(df_users['user_created_at'].dt.year < 2021) |
(~df_users['user_created_at'].notnull())]
# convert to datetime
df.created_at = pd.to_datetime(df.created_at)
df_merged.created_at = pd.to_datetime(df_merged.created_at)
df_merged.user_created_at = pd.to_datetime(df_merged.user_created_at)
df_users.user_created_at = pd.to_datetime(df_users.user_created_at)
Reddit Contributions (Comments / Submissions)¶
df.shape[0]
128408
px.bar(data_frame=df['submission_comment'].value_counts().to_frame().reset_index(),
x="index", y="submission_comment", color='submission_comment', text = 'submission_comment' ).update_layout(title='Comment or Submission',
xaxis_title='contribution category',
yaxis_title='number of contributions').update_traces(marker_color='#5296dd')
df['submission_comment'].value_counts().to_frame().reset_index()
| index | submission_comment | |
|---|---|---|
| 0 | comment | 120525 |
| 1 | submission | 7883 |
fig = px.pie(data_frame=df['submission_comment'].value_counts().to_frame().reset_index(), values='submission_comment', names='index',
title='Comment or Submission')
fig.show()
round(df['submission_comment'].value_counts() / df.shape[0] * 100,2)
comment 93.86 submission 6.14 Name: submission_comment, dtype: float64
df.author.value_counts().to_frame().head(10).reset_index()
| index | author | |
|---|---|---|
| 0 | -banned- | 17396 |
| 1 | AutoModerator | 1679 |
| 2 | 5th_Law_of_Robotics | 298 |
| 3 | CelebBattleVoteBot | 282 |
| 4 | Support_Johnny_Depp | 256 |
| 5 | DerHander | 237 |
| 6 | fluidmoviestar | 200 |
| 7 | empatheticapathetic | 114 |
| 8 | AutoNewsAdmin | 105 |
| 9 | wiklr | 104 |
fig = px.bar(df.author.value_counts().to_frame().head(10).reset_index(), x="author", y="index",
height=500,
title='Most commented user in 2020').update_traces(marker_color='#5296dd',).update_layout(
xaxis_title='number of comments',
yaxis_title='user name').update_traces(marker_color='#5296dd')
fig.update_yaxes(autorange="reversed")
round(df[df.author == '-banned-'].shape[0] / df.shape[0]*100,2)
13.55
df.author.value_counts()[:20]
-banned- 17396 AutoModerator 1679 5th_Law_of_Robotics 298 CelebBattleVoteBot 282 Support_Johnny_Depp 256 DerHander 237 fluidmoviestar 200 empatheticapathetic 114 AutoNewsAdmin 105 wiklr 104 pacmatt27 104 cracksniffer666 99 gaul66 96 toutfilm 95 rMemesMods 89 controlandr3sistanc3 89 Lethal_bizzle94 88 Egalitarianwhistle 80 Princess-La-Felix 80 AG_GreenZerg 79 Name: author, dtype: int64
AutoModerator is a system built into reddit that allows moderators to define "rules" (consisting of checks and actions) to be automatically applied to posts in their subreddit.
df_auto_moderator = df.query(" author == 'AutoModerator' ").reset_index(drop=True)
print(df_auto_moderator.shape)
df_auto_moderator.head(1)
(1679, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_fcxq6c4 | /r/Celebhub/comments/ejhpv4/amber_heard/fcxq6c4/ | Make sure to follow our community guidelines.\... | t3_ejhpv4 | r/Celebhub | AutoModerator | 2020-01-03 16:27:21 | Positive | Positive | 1.0 | submission | comment | 44 | amber_heard | 2 | ['https://redd.it', 'https://www.instagram.com'] | 2 |
df_auto_moderator.subreddit.value_counts().head(10)
r/JerkOffToCelebs 311 r/Celebhub 176 r/memes 169 r/OutOfTheLoop 135 r/unpopularopinion 100 r/AskReddit 99 r/iamatotalpieceofshit 66 r/DC_Cinematic 61 r/CelebBattleLeague 47 r/Drama 31 Name: subreddit, dtype: int64
df_auto_moderator['permalink'].iloc[26]
'/r/JerkOffToCelebs/comments/etthnt/imagine_amber_heard_laying_on_top_of_you_like_this/ffifkd6/'
df_auto_moderator.text.value_counts().head()
Make sure to follow our community guidelines.\n\n**[Get user flair](https://redd.it/e0a4mn) and check out our [Instagram page](https://www.instagram.com/celebtag) for more celebrity content!**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/Celebhub) if you have any questions or concerns.* 143 Rule 9 overused. No Johny Depp or Amber Heard memes at this time\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/memes) if you have any questions or concerns.* 105 **PLEASE READ ALL OF THIS BEFORE MESSAGING US:**\n\nThank you for your submission, but it has been removed due to lack of context. \n\n**Please see Rule 2** and repost with a **URL or a screenshot** (you can host it on imgur.com) **in your submission body** so that the users can better know what you're talking about and increase your chances for getting an answer. **Feel free to repost once you find a URL.** (Please remember to include the full URL: URL shorteners don't count.) Thanks!\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/OutOfTheLoop) if you have any questions or concerns.* 87 Your opinion about celebrity relationships has been reposted dozens of times today. Please join a celebrity gossip sub. Thanks.\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/unpopularopinion) if you have any questions or concerns.* 68 Your submission has been automatically removed for not including a valid category/subcategory tag. Tags are essential to an optimal browsing experience for our users.\n\nSince your post was removed automatically, you are free to resubmit it with an appropriate tag. You can find the tagging guide [here](/r/DC_Cinematic/wiki/linkflair#wiki_automated_tagging). Add a valid and appropriate tag in your submission title. Choose wisely, as posts with misleading tags are subject to removal.\n\n**Message the moderators if your post was removed despite being tagged with an input from the category list.**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/DC_Cinematic) if you have any questions or concerns.* 61 Name: text, dtype: int64
df_5th_Law_of_Robotics = df.query(" author == '5th_Law_of_Robotics' ").reset_index(drop=True)
print(df_5th_Law_of_Robotics.shape)
df_5th_Law_of_Robotics.head()
(298, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_ffk1d8o | /r/LeftWingMaleAdvocates/comments/eu0fth/petit... | Funny how the MeToo folks aren't saying anythi... | t3_eu0fth | r/LeftWingMaleAdvocates | 5th_Law_of_Robotics | 2020-01-26 04:27:01 | Positive | Positive | 18.0 | submission | comment | 11 | petition_to_remove_amber_heard_from_aquaman_2_due | 9 | [] | 0 |
| 1 | t1_ffm7uod | /r/LeftWingMaleAdvocates/comments/eu0fth/petit... | They took "listen and believe" to heart.\n\n\n... | t1_ffm2i45 | r/LeftWingMaleAdvocates | 5th_Law_of_Robotics | 2020-01-26 14:47:18 | Positive | Neutral | 9.0 | comment | comment | 52 | petition_to_remove_amber_heard_from_aquaman_2_due | 9 | [] | 0 |
| 2 | t1_fgahof1 | /r/iamatotalpieceofshit/comments/exo718/amber_... | And after suffering all this abuse he had to a... | t3_exo718 | r/iamatotalpieceofshit | 5th_Law_of_Robotics | 2020-02-02 13:49:50 | Negative | Neutral | 110.0 | submission | comment | 54 | amber_heard_is_a_pos | 5 | [] | 0 |
| 3 | t3_exotbj | /r/Egalitarianism/comments/exotbj/newly_releas... | Newly released audio has professional MeToo vi... | NaN | r/Egalitarianism | 5th_Law_of_Robotics | 2020-02-02 14:01:18 | Positive | Negative | 83.0 | NaN | submission | 22 | newly_released_audio_has_professional_metoo | 6 | [] | 0 |
| 4 | t1_fgajukp | /r/Egalitarianism/comments/exotbj/newly_releas... | As part of his male privilege Johnny was force... | t3_exotbj | r/Egalitarianism | 5th_Law_of_Robotics | 2020-02-02 14:02:18 | Negative | Neutral | 22.0 | submission | comment | 38 | newly_released_audio_has_professional_metoo | 6 | [] | 0 |
df_5th_Law_of_Robotics['permalink'].iloc[0]
'/r/LeftWingMaleAdvocates/comments/eu0fth/petition_to_remove_amber_heard_from_aquaman_2_due/ffk1d8o/'
df_5th_Law_of_Robotics.subreddit.value_counts().head(10)
r/videos 93 r/MensRights 34 r/Egalitarianism 31 r/iamatotalpieceofshit 30 r/LeftWingMaleAdvocates 29 r/SRSsucks 19 r/agedlikemilk 14 r/Toxic_Femininity 8 r/entertainment 8 r/meToo 7 Name: subreddit, dtype: int64
df_5th_Law_of_Robotics.text.value_counts().head()
Amber Heard, facing criminal sentencing for lying about abuse, doubles down by suddenly remembering being raped 2 No 2 You mean UN Human Rights Champion Amber Heard is a monster.\n\n\nAnd feminist and MeToo darling and domestic violence activist. 1 Yep 1 \n>Johnny has 19 eyewitness statements, 87 surveillance videotapes, audio (which rekindled this case) and video recordings that he has submitted to his lawyer.\n>\n\n\n\n\nIt's amazing that a man with all that against a woman who just said she was abused with no/contradictory evidence gets people thinking both were equally in the wrong. 1 Name: text, dtype: int64
df_Support_Johnny_Depp = df.query(" author == 'Support_Johnny_Depp' ").reset_index(drop=True)
print(df_Support_Johnny_Depp.shape)
df_Support_Johnny_Depp.head()
(256, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t3_fubrmn | /r/entertainment/comments/fubrmn/amber_heard_h... | Amber Heard hired private investigator to dig ... | NaN | r/entertainment | Support_Johnny_Depp | 2020-04-03 16:45:29 | Negative | Positive | 1.0 | NaN | submission | 54 | amber_heard_hired_private_investigator_to_dig_up | 8 | [] | 0 |
| 1 | t3_fw29cv | /r/MensRights/comments/fw29cv/amber_heard_coul... | Amber Heard could face up to 3 years in prison... | NaN | r/MensRights | Support_Johnny_Depp | 2020-04-06 16:53:07 | Negative | Negative | 458.0 | NaN | submission | 13 | amber_heard_could_face_up_to_3_years_in_prison | 10 | [] | 0 |
| 2 | t3_fw3cz2 | /r/entertainment/comments/fw3cz2/proof_amber_h... | PROOF Amber Heard S**T IN Johnny Depp's BED - ... | NaN | r/entertainment | Support_Johnny_Depp | 2020-04-06 17:50:30 | Positive | Neutral | 1.0 | NaN | submission | 11 | proof_amber_heard_st_in_johnny_depps_bed_and_more | 10 | [] | 0 |
| 3 | t3_fw3h6p | /r/MensRights/comments/fw3h6p/johnny_deppu00a0... | Johnny Depp\u00A0jokes about severed finger af... | NaN | r/MensRights | Support_Johnny_Depp | 2020-04-06 17:56:25 | Neutral | Negative | 12.0 | NaN | submission | 10 | johnny_deppu00a0jokes_about_severed_finger_after | 6 | [] | 0 |
| 4 | t3_fw3hv8 | /r/entertainment/comments/fw3hv8/exclusive_wat... | EXCLUSIVE: Watch as Johnny Depp describes how ... | NaN | r/entertainment | Support_Johnny_Depp | 2020-04-06 17:57:25 | Neutral | Neutral | 1.0 | NaN | submission | 28 | exclusive_watch_as_johnny_depp_describes_how_his | 8 | [] | 0 |
df_Support_Johnny_Depp['permalink'].iloc[0]
'/r/entertainment/comments/fubrmn/amber_heard_hired_private_investigator_to_dig_up/'
df_Support_Johnny_Depp.subreddit.value_counts().head(10)
r/entertainment 117 r/MensRights 39 r/pussypassdenied 32 r/videos 27 r/SupportForTheAccused 20 r/todayilearned 11 r/Petition 4 r/movies 3 r/beauty 1 r/JusticeServed 1 Name: subreddit, dtype: int64
df_Support_Johnny_Depp.text.value_counts()
Johnny Depp & Amber Heard Abuse Claims: Australia's Bloody Aftermath! NEW UNCENSORED AUDIO!! 11
Johnny Depp & Amber Heard Case Update: Amber's Parents Sided With Johnny? - NEW TEXTS & EVIDENCE!! - 10
Sign the Petition: Remove Amber Heard as L'Oreal Spokesperson 8
Johnny Depp & Amber Heard: The Truth and Timeline of The Case 6
Johnny Depp & Amber Heard Abuse Claims: Amber "just lost it" so Johnny LOST A FINGER! NEW EVIDENCE!! 6
..
Sign the Petition: Remove Amber Heard as L'Oreal Spokesperson #justiceforjohnnydepp 1
Petition To Drop Amber Heard from 'Aquaman 2' Nears Half a Million Signatures 1
Johnny Depp Deposition Describing His Finger As Mount Vesuvius, and Covering for Amber Heard! 1
PROOF Amber Heard S**T IN Johnny Depp's BED - And MORE! 1
The Petition To Remove Amber Heard From Aquaman 2 Hits Over 400K Signatures 1
Name: text, Length: 141, dtype: int64
it may be a bot which aims only to remain Amber Heard on trend, most contributions contains only her name.
df_users[df_users.user_name == 'DerHander']
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 27442 | DerHander | True | True | True | False | 1370.0 | 366459.0 | 2017-01-27 20:12:37 | others | others |
'This user created at 2017'
'This user created at 2017'
df_DerHander = df.query(" author == 'DerHander' ").reset_index(drop=True)
print(df_DerHander.shape)
df_DerHander.head()
(237, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t3_elfro8 | /r/femcelebs/comments/elfro8/amber_heard/ | Amber Heard | NaN | r/femcelebs | DerHander | 2020-01-07 18:49:10 | Neutral | Neutral | 7.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
| 1 | t3_emqu3a | /r/femcelebs/comments/emqu3a/amber_heard/ | Amber Heard | NaN | r/femcelebs | DerHander | 2020-01-10 13:21:41 | Neutral | Neutral | 13.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
| 2 | t3_eq774a | /r/femcelebs/comments/eq774a/amber_heard/ | Amber Heard | NaN | r/femcelebs | DerHander | 2020-01-17 21:57:37 | Neutral | Neutral | 4.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
| 3 | t3_et7dfd | /r/femcelebs/comments/et7dfd/amber_heard/ | Amber Heard | NaN | r/femcelebs | DerHander | 2020-01-24 07:59:21 | Neutral | Neutral | 8.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
| 4 | t3_etojm2 | /r/femcelebs/comments/etojm2/amber_heard/ | Amber Heard | NaN | r/femcelebs | DerHander | 2020-01-25 08:59:59 | Neutral | Neutral | 7.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
df_DerHander.subreddit.value_counts().head(10)
r/femcelebs 147 r/celeb_blondes 21 r/Blonde 21 r/FamousFaces 6 r/FamousBabes 6 r/cleavage 4 r/sexycelebs 4 r/celeb_bellybuttons 3 r/legs 3 r/Celebrityasses 2 Name: subreddit, dtype: int64
df_DerHander.text.value_counts().head(10)
Amber Heard 212 Idgaf 1 I know what you wanted to allude to. 1 Yes, but the sexy one. 1 Amber Heard & Gal Gadot 1 But a hot liar 1 Yes, but I give a fuck. I post what I like. If you want you can post what you like. 1 Amber Heard vs. Elisabeth Moss 1 Not "but", "and".😜 1 I don't see a problem for me. They'll have to work that out for themselves. 1 Name: text, dtype: int64
This account compare amber heared case with harvey weinstein.
# check the date this account was creted
str(df_users[df_users.user_name == 'fluidmoviestar']['user_created_at'].values[0])
'2015-04-30T04:23:28.000000000'
df_fluidmoviestar = df.query(" author == 'fluidmoviestar' ").reset_index(drop=True)
print(df_fluidmoviestar.shape)
df_fluidmoviestar.head()
(200, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t3_gmk0zo | /r/unpopularopinion/comments/gmk0zo/if_harvey_... | If Harvey Weinstein deserved to go to prison (... | NaN | r/unpopularopinion | fluidmoviestar | 2020-05-19 07:37:45 | Neutral | Neutral | 4266.0 | NaN | submission | 20 | if_harvey_weinstein_deserved_to_go_to_prison_tbh | 9 | [] | 0 |
| 1 | t1_fr43eu3 | /r/unpopularopinion/comments/gmk0zo/if_harvey_... | I’ll do some digging, I guess I haven’t pulled... | t1_fr432l7 | r/unpopularopinion | fluidmoviestar | 2020-05-19 07:47:45 | Positive | Neutral | 210.0 | comment | comment | 18 | if_harvey_weinstein_deserved_to_go_to_prison_tbh | 9 | [] | 0 |
| 2 | t1_fr4458y | /r/unpopularopinion/comments/gmk0zo/if_harvey_... | Thanks for the briefing, I appreciate your help. | t1_fr43tal | r/unpopularopinion | fluidmoviestar | 2020-05-19 07:59:29 | Positive | Positive | 36.0 | comment | comment | 8 | if_harvey_weinstein_deserved_to_go_to_prison_tbh | 9 | [] | 0 |
| 3 | t1_fr44ols | /r/unpopularopinion/comments/gmk0zo/if_harvey_... | Absolutely... it’s not a short list of fraud a... | t1_fr44h9p | r/unpopularopinion | fluidmoviestar | 2020-05-19 08:08:19 | Positive | Negative | 12.0 | comment | comment | 15 | if_harvey_weinstein_deserved_to_go_to_prison_tbh | 9 | [] | 0 |
| 4 | t1_fr44wrf | /r/unpopularopinion/comments/gmk0zo/if_harvey_... | As much as I agree in principle, I’d still nee... | t1_fr44ic2 | r/unpopularopinion | fluidmoviestar | 2020-05-19 08:12:05 | Positive | Neutral | 16.0 | comment | comment | 69 | if_harvey_weinstein_deserved_to_go_to_prison_tbh | 9 | [] | 0 |
df_fluidmoviestar.subreddit.value_counts().head(10)
r/unpopularopinion 200 Name: subreddit, dtype: int64
df_fluidmoviestar['text'].value_counts()
Oh, so much evidence.\n\nI appreciate wanting to give people the benefit of the doubt, but when reasonable doubt is gone, defending a monster only makes anyone or anything associated with the abuser look foolish for their insistence. 1
He represents a male form of extracting value from victims. She represents a female form of the same. It’s just a point of comparison around the same tired topics of what constitutes abuse, consent, power, etc. 1
Perjury is a criminal offense. Time will tell. 1
It’s hyperbolic, yes, but the point was to draw attention to differing strategies that male abusers and female abusers use to silence their victims and generate codependency. That’s all. 1
That’s a fact, though I don’t see how they ever get us to mind-control. Maybe we secretly have the brain better mapped out than popularly understood. 1
..
In what way is his behavior toxic? You think I’m 17, but this is your level of engagement with a case of a distinct man and woman preying on their victims? Men don’t commit crimes for reasons identical to women. Equivalence needn’t be viewed as identical. Harvey sparked metoo, Amber threatens its legitimacy. She is a criminal, and a prison sentence is suitable for her crimes, although at a lower number of years, as her crimes are not identical to Harvey’s. 1
Kudos 1
Harvey didn’t take advantage of partners, correct. Amber did. I find that more offensive. Most of the things Harvey did (but wasn’t convicted of) were temporary sexual situations with voluntarily complying strangers, not intimate partners with legal obligations holding victim and victimizer in a race to the bottom. Seek clarification, but don’t assume of me. 1
Different countries, different challenges. The US’s male/female ratio is nowhere near as screwed as India’s. \n\nThat said, Jeffery Epstein “suicided” because of endless trafficking and abuse. He’s not the only one. Hearing about something isn’t the measure of whether or not something happens. The tree still falls in the woods.\n\nI stand by it, India is no more deserving of attention for rape than any other country. Titles like that might unnecessarily convince people to ignore the issue in their own countries. 1
Okay, where’s the article? 1
Name: text, Length: 200, dtype: int64
df_fluidmoviestar_g = df_fluidmoviestar.groupby(df_fluidmoviestar.created_at.dt.date).size().reset_index(name='n_contributions')
df_fluidmoviestar_g
| created_at | n_contributions | |
|---|---|---|
| 0 | 2020-05-19 | 183 |
| 1 | 2020-05-20 | 17 |
fig = px.bar(df_fluidmoviestar_g,
x='created_at',
y='n_contributions', title='The number of "fluidmoviestar" contributions in 2020')
fig.update_layout(
xaxis = dict(
title='Contribution Date',
tickmode = 'array',
tickvals = df_fluidmoviestar_g.created_at,
)
)
fig.update_traces(marker_color='#5296dd',
marker_line_width=2, opacity=1, textposition='auto')
fig.show()
183 contributions in only 1 day!
The rest contributions also in the next day?!
fig = px.bar(df_fluidmoviestar[df_fluidmoviestar.created_at.dt.day == 19].created_at.dt.hour.value_counts().to_frame().sort_index())
fig.update_layout(
title="title='Number of Contribution in each hour of 19 may 2020 '",
xaxis_title="Hour of day 0-23",
yaxis_title="n_of_contributions",
showlegend=False,
xaxis = dict(
tickmode = 'linear')
)
fig = px.bar(df_fluidmoviestar[df_fluidmoviestar.created_at.dt.day == 20].created_at.dt.hour.value_counts().to_frame().sort_index())
fig.update_layout(
title="title='Number of Contribution in each hour of 20 may 2020 '",
xaxis_title="Hour of day 0-23",
yaxis_title="n_of_contributions",
showlegend=False,
xaxis = dict(
tickmode = 'linear')
)
we can say that all contributions of this user were made in the same day as he started to contribute at 19 may at 7 AM and he continued till the next day morining, about 30 hours
The most recent news was related to violence were in last week as; – May 13: The court gives permission for Depp’s former partners Vanessa Paradis and Winona Ryder – who both say Mr Depp was “never violent” to them – to give evidence. Heard’s former personal assistant Kate James is also permitted to give evidence.
Negtive
df_empatheticapathetic = df.query(" author == 'empatheticapathetic' ").reset_index(drop=True)
print(df_empatheticapathetic.shape)
df_empatheticapathetic.head()
(114, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_fg80m2u | /r/entertainment/comments/ewymip/amber_heard_a... | Why are you quick to believe women? They lie, ... | t1_fg70f08 | r/entertainment | empatheticapathetic | 2020-02-02 01:19:03 | Positive | Positive | -4.0 | comment | comment | 10 | amber_heard_admits_to_hitting_exhusband_johnny | 7 | [] | 0 |
| 1 | t1_fg80qo7 | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | Women stick up for other women. They are a hiv... | t1_fg7zmrv | r/iamatotalpieceofshit | empatheticapathetic | 2020-02-02 01:20:39 | Negative | Neutral | 10.0 | comment | comment | 19 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 2 | t1_fg81k2n | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | That's a very open ended question. I couldn't ... | t1_fg81e01 | r/iamatotalpieceofshit | empatheticapathetic | 2020-02-02 01:30:55 | Positive | Neutral | -6.0 | comment | comment | 21 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 3 | t1_fg82nmf | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | I'm sexist because society sticks up for lying... | t1_fg81oe4 | r/iamatotalpieceofshit | empatheticapathetic | 2020-02-02 01:44:53 | Neutral | Negative | 8.0 | comment | comment | 51 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 4 | t1_fg83zom | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | >I said it’s unfortunate everyone rallied behi... | t1_fg83kdn | r/iamatotalpieceofshit | empatheticapathetic | 2020-02-02 02:02:01 | Negative | Neutral | 7.0 | comment | comment | 203 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
df_empatheticapathetic.subreddit.value_counts().head(10)
r/MensRights 63 r/iamatotalpieceofshit 14 r/WeinsteinEffect 14 r/awfuleverything 7 r/pussypassdenied 5 r/PussyPass 4 r/Toxic_Femininity 3 r/entertainment 2 r/PurplePillDebate 1 r/JusticeForJohnnyDepp 1 Name: subreddit, dtype: int64
df_empatheticapathetic.text.value_counts()
Course fam, you know how it be. 1
Yeah it wasn't the woman who bragged about abusing her partner and **bragging about the fact she will get away with it because she's a girl**. No it's a very confusing case 🤔.\n\nIt's not like she has a history of domestic abuse with her other partne-oh wait...\n\nYou on the other hand have a clear "women good men bad" agenda. And most men have been shocked awake by this recent Johnny Depp case. The plausible deniability is gone and you feminists trying to do damage control are displaying your bigotry in plain sight.\n\nHey, you wanted 'equality'. Here it is. 1
What do you think about all the claims of harassment that he wasn't convicted on? 1
This whole thing has been a bit of a revelation. Him actually losing in court has swayed so much more public support to his side than if he won. But we honestly couldn’t have expected that to happen. 1
How dumb are you? One gender is getting punished and one gender isn’t for the same crimes? And you ask this question on a post about how people believed Amber Heard over Johnny Depp because he was a man and she was a woman?\n\nWhat website are you talking about?\n\nHow old are you? For real? I don’t want to hurt you with too much logic if you aren’t really old enough to be debating on the internet. \n\nLet’s get amber heard behind bars first. Sound like a good plan? The first step would be to get women like you who have a clear agenda to admit Amber Heard is a disgusting human being, a liar, an abuser and that she should be in jail. And then when I feel like you are representing equality, I will do the same.\n\nMen don’t get off for crimes. They even go to jail for false crimes. Check out /r/falserapeaccusations You can see a list of crimes that women get away with over at /r/pussypass \n\nGlad to hear you’re finally on the right side of history. Now let’s go get those women in jail!! 1
..
Won’t happen 1
Censorship here is being downvoted until you can’t be seen, even if you are stating facts. So yes, I am not allowed to acknowledge and discuss the misandrist agenda in society and on this sub. 1
Have you not noticed that? 1
>No it isn’t. It didn’t start off that way. It was actually from a black woman who was sick of getting cat called and realized in her environment she was more exposed to harassment. And nobody cared. Please don’t tell me that that is BS.\n\nWho gives a fuck how it started. We're talking about how it is utilised now.\n\n>False accusations exist yes but that doesn’t take away from what the initial goal was from the moment — raising awareness.\n\nWow you sound empathetic. Raising awareness is worthless and creates a toxic culture where anyone can accuse anyone else of anything and people will believe it instead of waiting for legal discourse. We have a full legal system in place for this.\n\nBut hey if you want women to keep losing credibility through bullshit movements like metoo, then be my guest. You'll be the one losing out as less and less women are trusted or believed as a result of this entitled selfish thinking.\n\nYour agenda is crystal clear. Why are you on mens rights if you don't care about mens rights? 1
>I said it’s unfortunate everyone rallied behind this case that he abused her without correct information an it ended up her the abuser. I said all this support came off the me too movement and people decided to back up the wrong situation because she ended up being the abuser.\n\nWomen and idiot men push the narrative #believewomen. "Women couldn't possibly lie." All the evidence was stacked against her for years but instead people 'cancelled' Johnny Depp because abuser=male and victim=female, and Amber Heard became a womens rights ambassador of domestic abuse. And here you are in your other comment still defending her and again trying to twist the narrative. You're a fucking agenda ridden feminist piece of shit, and now your type is being called out for the hypocrites you really are.\n\nWomen support other women, like you're doing here. Because you gain the social power and leverage to 'cancel' people like you cancelled Johnny Depp whenever you want, with bullshit movements like #metoo (guilty before being proven innocent) and #believewomen (because women are incapable of lying). Go ask the guys over at /r/falserapeaccusations whether they #believewomen.\n\nYou have only proven women are a hivemind and that you are a huge sexist. 1
Name: text, Length: 114, dtype: int64
df_empatheticapathetic['permalink'].iloc[5]
'/r/iamatotalpieceofshit/comments/ex9ge9/amber_heard_admits_abusing_johnny_depp_even/fg85ohq/'
# check the date this account was creted
str(df_users[df_users.user_name == 'AutoNewsAdmin']['user_created_at'].values[0])
'2016-10-27T00:30:08.000000000'
df_auto = df.query(" author == 'AutoNewsAdmin' ").reset_index(drop=True)
print(df_auto.shape)
df_auto.head()
(105, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t3_f6wct3 | /r/NYPOSTauto/comments/f6wct3/fashion_petition... | [Fashion] - Petitions to fire Amber Heard as L... | NaN | r/NYPOSTauto | AutoNewsAdmin | 2020-02-20 17:24:35 | Neutral | Neutral | 3.0 | NaN | submission | 12 | fashion_petitions_to_fire_amber_heard_as_loréals | 8 | [] | 0 |
| 1 | t3_f9znse | /r/INDEPENDENTauto/comments/f9znse/arts_johnny... | [Arts] - Johnny Depp threatened to 'burn' and ... | NaN | r/INDEPENDENTauto | AutoNewsAdmin | 2020-02-26 20:29:25 | Neutral | Negative | 1.0 | NaN | submission | 15 | arts_johnny_depp_threatened_to_burn_and_drown | 8 | [] | 0 |
| 2 | t3_fxctl9 | /r/GUARDIANauto/comments/fxctl9/world_amber_he... | [World] - Amber Heard to testify in Johnny Dep... | NaN | r/GUARDIANauto | AutoNewsAdmin | 2020-04-08 19:18:20 | Negative | Neutral | 4.0 | NaN | submission | 13 | world_amber_heard_to_testify_in_johnny_depp_case | 9 | [] | 0 |
| 3 | t3_g35nxe | /r/INDEPENDENTauto/comments/g35nxe/arts_johnny... | [Arts] - Johnny Depp joins Instagram and hints... | NaN | r/INDEPENDENTauto | AutoNewsAdmin | 2020-04-17 16:47:05 | Neutral | Neutral | 1.0 | NaN | submission | 15 | arts_johnny_depp_joins_instagram_and_hints_at | 8 | [] | 0 |
| 4 | t3_glz9kk | /r/GUARDIANauto/comments/glz9kk/world_johnny_d... | [World] - Johnny Depp libel claim can use Ambe... | NaN | r/GUARDIANauto | AutoNewsAdmin | 2020-05-18 10:52:10 | Positive | Neutral | 1.0 | NaN | submission | 15 | world_johnny_depp_libel_claim_can_use_amber_heard | 9 | [] | 0 |
df_auto.subreddit.value_counts().head(10)
r/GUARDIANauto 19 r/INDEPENDENTauto 17 r/BBCauto 11 r/SCMPauto 10 r/IOLauto 9 r/CHICAGOTRIBauto 9 r/SMHauto 7 r/TELEGRAPHauto 5 r/IRISHTIMESauto 4 r/TORONTOSTARauto 4 Name: subreddit, dtype: int64
df_auto_contributions = df_auto.groupby(df_auto.created_at.dt.date).size().reset_index(name='n_contributions')
df_auto_contributions
| created_at | n_contributions | |
|---|---|---|
| 0 | 2020-02-20 | 1 |
| 1 | 2020-02-26 | 1 |
| 2 | 2020-04-08 | 1 |
| 3 | 2020-04-17 | 1 |
| 4 | 2020-05-18 | 1 |
| 5 | 2020-06-30 | 1 |
| 6 | 2020-07-04 | 1 |
| 7 | 2020-07-07 | 4 |
| 8 | 2020-07-08 | 6 |
| 9 | 2020-07-09 | 2 |
| 10 | 2020-07-10 | 3 |
| 11 | 2020-07-11 | 1 |
| 12 | 2020-07-13 | 5 |
| 13 | 2020-07-14 | 6 |
| 14 | 2020-07-15 | 5 |
| 15 | 2020-07-16 | 6 |
| 16 | 2020-07-17 | 2 |
| 17 | 2020-07-19 | 1 |
| 18 | 2020-07-20 | 11 |
| 19 | 2020-07-21 | 9 |
| 20 | 2020-07-22 | 10 |
| 21 | 2020-07-23 | 7 |
| 22 | 2020-07-24 | 6 |
| 23 | 2020-07-26 | 2 |
| 24 | 2020-07-27 | 1 |
| 25 | 2020-07-28 | 5 |
| 26 | 2020-07-29 | 1 |
| 27 | 2020-10-16 | 1 |
| 28 | 2020-10-30 | 1 |
| 29 | 2020-11-02 | 2 |
| 30 | 2020-11-03 | 1 |
This account has regular contrbutions
df_auto.text.value_counts()
[World] - Amber Heard denies fabricating injuries after Johnny Depp allegedly threw phone at her 2
[World] - Johnny Depp threatened to kill me, Amber Heard tells court 2
[World] - Johnny Depp’s ex-wife Amber Heard accused of ‘stealing’ sex abuse story 1
[World] - Amber Heard says ex-husband Johnny Depp threatened to kill her 1
[World] - ’He’s nuts Mom’ - Amber Heard shared fears about Johnny Depp in 2013 1
..
[UK] - Johnny Depp and Amber Heard: Couple rowed 'like schoolchildren', says ex-employee 1
[UK] - Trolls, tweets and famous friends: the vicious PR war between Johnny Depp and Amber Heard 1
[World] - Amber Heard denies fabricating injuries in Depp libel trial 1
[World] - Johnny Depp threw bottles 'like grenades', former wife Amber Heard says 1
[UK] - Johnny Depp 'insulted by Amber Heard during Bahamas trip', says his employee 1
Name: text, Length: 103, dtype: int64
df_pacmatt27 = df.query(" author == 'pacmatt27' ").reset_index(drop=True)
print(df_pacmatt27.shape)
df_pacmatt27.head()
(104, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_gbgqrp7 | /r/MensRights/comments/jprmy5/petition_to_have... | Just curious how you can identify with a movem... | t1_gbgk64v | r/MensRights | pacmatt27 | 2020-11-07 16:29:05 | Negative | Neutral | 38.0 | comment | comment | 16 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 1 | t1_gbgqs10 | /r/MensRights/comments/jprmy5/petition_to_have... | Just curious how you can identify with a movem... | t1_gbglcnj | r/MensRights | pacmatt27 | 2020-11-07 16:29:09 | Negative | Neutral | -3.0 | comment | comment | 16 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 2 | t1_gbgsjai | /r/MensRights/comments/jprmy5/petition_to_have... | No, they're not and it's not a strong term. Fe... | t1_gbgryj9 | r/MensRights | pacmatt27 | 2020-11-07 16:42:21 | Positive | Neutral | 23.0 | comment | comment | 75 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 3 | t1_gbgsr40 | /r/MensRights/comments/jprmy5/petition_to_have... | I asked it of two people who proclaimed their ... | t1_gbgru7m | r/MensRights | pacmatt27 | 2020-11-07 16:43:57 | Neutral | Negative | 11.0 | comment | comment | 30 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 4 | t1_gbgsvil | /r/MensRights/comments/jprmy5/petition_to_have... | Egalitarian. | t1_gbgrpz2 | r/MensRights | pacmatt27 | 2020-11-07 16:44:45 | Neutral | Neutral | 17.0 | comment | comment | 1 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
df_pacmatt27['permalink'].iloc[0]
'/r/MensRights/comments/jprmy5/petition_to_have_amber_heard_removed_as_the/gbgqrp7/'
df_pacmatt27.subreddit.value_counts().head(10)
r/MensRights 104 Name: subreddit, dtype: int64
df_pacmatt27.text.value_counts().head(15)
Please do. 2 Just curious how you can identify with a movement which has essentially become a hate group? 2 K, bye. 2 K. 2 Not sure how to phrase that question more simply. 1 I am. Next. 1 Ok but can you actually show me any rights men have which women don't in developed countries? Y'no, ones that aren't total shitholes. Can you give me real examples of what feminism can actually do to be of value? Not parroted rhetoric and a gross misunderstanding of human history. 1 I wish I could too but you keep irritating me.\n\nGot plenty. Fuck off. 1 You are indeed. Now go away. 1 Just behaving like feminists do. It's irritating isn't it? When you start actually investing some effort in helping men, I'll stop comparing suffering. Since, apparently, we have to fix all the most important issues first and all of those involve women making shit up. 1 I can't m8, covid-19. 1 So what you're saying is you're a simpleton? 1 Not really. 1 > There are multiple different branches of Feminism.\n\nPlease don't patronise me. I'm more than aware of that. \n\n>The type you're probably referring to is radical feminism which is more anarchist in nature.\n\nWrong, I am referring to mainstream third wave feminism, which is the most popular form of feminism at present.\n\n>Most Feminists you'll meet in real life literally just want equity for genders\n\nWrong. Most feminists I meet in real life are hypocrites with a startling lack of awareness of male issues, an inability to react to dissent rationally and a spiteful, greedy, vengeful victim complex.\n\n>Anti-men feminists are the exception, not the rule.\n\nWrong and, even if they were, they are not the ones informing social and legal policy and lack the power to do anything meaningful. 1 No, I see what is actually there.\n\nYeah, that's bullshit. When you want to discuss this like someone with integrity would, you let me know. 1 Name: text, dtype: int64
df_wiklr = df.query(" author == 'wiklr' ").reset_index(drop=True)
print(df_wiklr.shape)
df_wiklr.head()
(104, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_fg9qcsr | /r/DeFranco/comments/ex0ifz/full_audio_recordi... | Not only media outlets but youtube commentary ... | t1_fg7592b | r/DeFranco | wiklr | 2020-02-02 11:12:38 | Positive | Negative | 4.0 | comment | comment | 19 | full_audio_recording_of_amber_heard_and_johnny | 8 | [] | 0 |
| 1 | t1_fg9u3n6 | /r/entertainment/comments/ewymip/amber_heard_a... | In his apology, he admitted to the things prin... | t1_fg7pqie | r/entertainment | wiklr | 2020-02-02 11:33:38 | Positive | Neutral | 5.0 | comment | comment | 105 | amber_heard_admits_to_hitting_exhusband_johnny | 7 | [] | 0 |
| 2 | t3_exna8x | /r/WeinsteinEffect/comments/exna8x/i_did_start... | I did start a physical fight: Amber Heard admi... | NaN | r/WeinsteinEffect | wiklr | 2020-02-02 11:41:04 | Neutral | Neutral | 316.0 | NaN | submission | 12 | i_did_start_a_physical_fight_amber_heard_admits | 9 | [] | 0 |
| 3 | t1_fga7t0d | /r/WeinsteinEffect/comments/exna8x/i_did_start... | Because in those tapes she admitted in startin... | t1_fga4ebr | r/WeinsteinEffect | wiklr | 2020-02-02 12:51:21 | Negative | Negative | 38.0 | comment | comment | 108 | i_did_start_a_physical_fight_amber_heard_admits | 9 | [] | 0 |
| 4 | t1_fgac52w | /r/WeinsteinEffect/comments/exna8x/i_did_start... | I dont know, I feel people are afraid of admit... | t1_fga99tq | r/WeinsteinEffect | wiklr | 2020-02-02 13:18:45 | Negative | Negative | 20.0 | comment | comment | 104 | i_did_start_a_physical_fight_amber_heard_admits | 9 | ['https://www.tmz.com'] | 1 |
df_wiklr['permalink'].iloc[0]
'/r/DeFranco/comments/ex0ifz/full_audio_recording_of_amber_heard_and_johnny/fg9qcsr/'
df_wiklr.subreddit.value_counts().head(10)
r/entertainment 25 r/videos 20 r/WeinsteinEffect 19 r/AskWomen 7 r/television 7 r/unpopularopinion 5 r/NoStupidQuestions 4 r/harrypotter 3 r/meToo 2 r/CaptainSparrowmemes 2 Name: subreddit, dtype: int64
df_wiklr.text.value_counts().head(15)
Yes, the Bieber accusations were unvetted but publications printed it anyway because he denied it. Holding the media to a higher standard was my point in the previous thread. 1 Back then she did have enough evidence leaked to sway public opinion. \n\nShe went to court with bruises, she had additional photos / expose in People Magazine, one of her friends wrote an article why they called 911. There was a video showing Johnny having a drunken outburst. She had more things that sold clicks. \n\nWhile Johnny's family & friends, former partners were vouching for him. Amber's arrest records were dug up including her mug shots and the DV case against her ex-gf Tasya. Her demand for the 50k a month spousal support, 3 penthouses and car for a mutual settlement was leaked. Her TRO was dismissed with prejudice. There was enough to insert doubt but not enough to defend himself. \n\nHis defense - PR wise wasnt enough to debunk her claims. While the deposition that includes the tape were available back in 2016, it was hidden under their mutual NDA and the $7M settlement he gave Amber. It made it look like hush money. What's worse is the statement that they released stated how no one fabricated evidence for financial gain. \n\nAdditional video surveillance / evidence in his defense was uncovered much later after Johnny reached a settlement with his former lawyers. 1 There's two released this week: \n\n* [2015 Audio Recording](https://www.dailymail.co.uk/news/article-7947733/Amber-Heard-admits-hitting-ex-husband-Johnny-Depp-pelting-pots-pans-tape.html): Discusses their fight with Amber admitting she hit, chased and instigated fights with Depp (recorded using Heard's phone)\n* [May 2016 Phone Call](https://www.dailymail.co.uk/news/article-7966723/Amber-Heard-ridicules-Johnny-Depp-claiming-hes-domestic-violence-victim.html): Happened after Heard accused Depp of domestic abuse (recorded by Depp) 1 He wasn't in a good place to fight anything at that time. His finances in jeopardy, issues with his lawyers, his mother died, his new wife not only divorcing him but also accusing him of domestic abuse. \n\nHe was fine going to court but Amber was seeking spousal support for a settlement. In the tape he was asking for things to end peacefully. In hindsight it was a mistake for him to settle and not take Amber to court. \n\nThe reason the tapes are out now is because its part of a trial against The Sun. I think he is now fighting to clear his name legally, instead of using the media like Amber does. 1 I went back. Her lawyers first said that Depp is lying about Amber's abuse being one of them. Compared to a recent statement acknowledging Depp was also a victim - and this only after the audio tapes were leaked. \n\nAmber Heard's domestic violence case was dismissed with prejudice but you never heard about it in the news. Everyone only heard about her filing the restraining order, getting a $7M settlement and donating it to charity.\n\nThe silence about their deposition where Amber lied multiple times is deafening. A lot of these details were published way in 2016 but didn't make major news publications. 1 * The DM link points to Josh's deposition video that mentions Cara & Elon\n* The lie was she first made it look like she was fleeing from Johnny's abuse but the audio tells the opposite and she was trying to get in the bathroom (door swings inwards thereby JD getting hit). In another audio she specifically recounts how JD always leaves when they fight which corroborates a pattern of her getting physical, and he splits. \n* Under 9/12/2019 - Defendant's Motion to Compel: \n\n> documents and communications between ... any of plaintiff's [romantic partners](https://imgur.com/a/Xbm4GBE) from 2010 to present\n\nAmber argued that JD should prove he has never hit a woman and instead subpoenaed his exes. Else there would be no need for Vanessa or Winona to make declarations, nor for them to be compelled & accepted to testify in the adjacent Sun/NGN lawsuit. 1 Yeah Elon Musk was Amber Heard's rebound following her accusations against Depp. \n\nElon broke up with her citing different work schedules. I kinda wonder if Elon suffered the same fate or believes Depp now. 1 Tasya called the police on Amber Heard. Beverly was very vocal about this on facebook and was clear on her arrest about Heard. You were adamant it was a male officer but why did you not include the gay female cop who arrested her? They didn't mention the gender of the other officer you're saying. So what's his name? 1 Rumor is Elon Musk is paying for Amber Heard's legal team. \n\nI was wondering how she got so much media and legal backing, against an A List celebrity no less. It was because she was seeing Musk before she got her divorce. 1 I read the case files, then read your comment and was surprised this was published before. \n\nThey say Stephen's message is proof but it doesn't seem like he was a witness. He was relaying to Depp what Heard told him. Weaponizes his apology as an admittance of guilt even if he doesn't remember what happened. Still not really as damning as the audio tapes, which is labeled "first" by Depp's lawyer. \n\nSo far the audio confession is the only definitive proof of one of them being abusive. 1 No it actually happened(2016) a year prior MeToo. But it caught steam again when JK defended his casting Fantastic Beasts(2017), then the WaPo article(2018). 1 * The specific deposition that involves Elon & Cara can be found [here](https://www.dailymail.co.uk/news/article-8426719/Cara-Delevingne-three-way-affair-Amber-Heard-Elon-Musk.html).\n* Another deposition where Amber is caught lying by her own audio tape is [here](https://youtu.be/-sKyN0_D_ec). \n* Other transcripts of depositions can be found in Amber & Johnny's declaration available on the [fairfax website.](https://www.fairfaxcounty.gov/circuit/high-profile-cases)\n* You are correct it is about a defamation case. But it is more sensational to think the story is about a three-way affair rather than them being witnesses for the lawsuit. \n* Also if the issue is making it about sexual partners, you should ask Amber why she subpoenaed Johnny's exes like Winona Ryder, Angelina Jolie, Ruth Wilson, & others. 1 People came after Rowling so hard for defending Depp too. And it took 4 years to any of this to come to light. \n\nIf it isn't the right time to reevaluate how the fanbase reacts to news now, idk when that time will come. 1 Not planning but corroboration. Her lawyers have been avoiding a trial for this very reason because her own parents, her own recording claims she pursued the restraining order in fear she will lose the condos housing her friends. Same friends who corroborated her restraining order that was dismissed with prejudice, same friends who went to the media to corroborate her abuse allegations. 1 There was where the doctor said she did it and Amber said sorry and she didn't mean to. They all lied how Johnny's finger was cut off at that time because it would've been a huge scandal. But the judge only considered Amber's testimony in court and the inconsistent reasons his body guards made and Johnny's own text to the same doctor. 1 Name: text, dtype: int64
Check wether the users with the most contributions are mod, gold or having a verified email¶
df.author.value_counts().nlargest(n=25)
-banned- 17396 AutoModerator 1679 5th_Law_of_Robotics 298 CelebBattleVoteBot 282 Support_Johnny_Depp 256 DerHander 237 fluidmoviestar 200 empatheticapathetic 114 AutoNewsAdmin 105 wiklr 104 pacmatt27 104 cracksniffer666 99 gaul66 96 toutfilm 95 rMemesMods 89 controlandr3sistanc3 89 Lethal_bizzle94 88 Egalitarianwhistle 80 Princess-La-Felix 80 AG_GreenZerg 79 bufedad 78 Threwaway42 77 reptilesocks 74 AutoNewspaperAdmin 71 EtherMan 68 Name: author, dtype: int64
check_list = df.author.value_counts().nlargest(n=25).index.tolist()[1:]
check_list
['AutoModerator', '5th_Law_of_Robotics', 'CelebBattleVoteBot', 'Support_Johnny_Depp', 'DerHander', 'fluidmoviestar', 'empatheticapathetic', 'AutoNewsAdmin', 'wiklr', 'pacmatt27', 'cracksniffer666', 'gaul66', 'toutfilm', 'rMemesMods', 'controlandr3sistanc3', 'Lethal_bizzle94', 'Egalitarianwhistle', 'Princess-La-Felix', 'AG_GreenZerg', 'bufedad', 'Threwaway42', 'reptilesocks', 'AutoNewspaperAdmin', 'EtherMan']
# get a data frame with the most negative-comments users
df_check = df_users[df_users['user_name'].isin(check_list)]
print(df_check.shape)
df_check.head(2)
(24, 10)
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 4432 | AutoModerator | True | True | True | False | 1000.0 | 1000.0 | 2012-01-05 05:24:28 | others | others |
| 5795 | EtherMan | True | False | False | False | 56411.0 | 698.0 | 2012-05-13 02:00:36 | others | others |
df_check['user_name'].nunique()
24
for col in df_check.columns:
if col not in ['user_name', 'user_created_at']:
print('The value counts of the users with the most contributions: ' + col)
print(df_check[col].value_counts())
print('\n')
The value counts of the users with the most contributions: has_verified_email True 21 False 3 Name: has_verified_email, dtype: int64 The value counts of the users with the most contributions: is_mod True 18 False 6 Name: is_mod, dtype: int64 The value counts of the users with the most contributions: is_gold False 17 True 7 Name: is_gold, dtype: int64 The value counts of the users with the most contributions: is_banned False 20 True 4 Name: is_banned, dtype: int64 The value counts of the users with the most contributions: comment_karma 100113.0 1 56411.0 1 149876.0 1 1000.0 1 93039.0 1 10.0 1 -100.0 1 213108.0 1 36552.0 1 73.0 1 77741.0 1 219601.0 1 361.0 1 1370.0 1 46342.0 1 9738.0 1 6637.0 1 5629.0 1 1063.0 1 1.0 1 Name: comment_karma, dtype: int64 The value counts of the users with the most contributions: link_karma 1.0 2 681.0 1 1289.0 1 1000.0 1 6145.0 1 2484.0 1 301.0 1 249122.0 1 14476.0 1 245787.0 1 366459.0 1 25821.0 1 1925.0 1 20315.0 1 1632.0 1 36237.0 1 4746.0 1 7398.0 1 698.0 1 Name: link_karma, dtype: int64 The value counts of the users with the most contributions: banned_unverified others 17 banned 4 unverified 3 Name: banned_unverified, dtype: int64 The value counts of the users with the most contributions: creation_year others 12 2019 5 banned 4 2018 2 2020 1 Name: creation_year, dtype: int64
df_check['comment_karma'].mean(), df_check['comment_karma'].median()
(50928.25, 8187.5)
df_check['comment_karma'].min(), df_check['comment_karma'].max()
(-100.0, 219601.0)
df_check['link_karma'].mean(), df_check['link_karma'].median()
(49325.9, 3615.0)
df_check['link_karma'].min(), df_check['link_karma'].max()
(1.0, 366459.0)
# pd.set_option('display.max_colwidth', None)
suspected_dict = {}
df_fuc = df[df.text.str.lower().str.contains('fuck')]
print(df_fuc.shape)
df_fuc.head()
(8468, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_fcou3a9 | /r/CelebAssPussyMouth/comments/ei1vxg/natalie_... | Fuck Anne Hathaway, watch Amber Heard, jack of... | t3_ei1vxg | r/CelebAssPussyMouth | azobran22 | 2020-01-01 01:19:48 | Negative | Negative | 2.0 | submission | comment | 11 | natalie_portman_anne_hattaway_and_amber_heard_sex | 8 | [] | 0 |
| 1 | t1_fcpccc4 | /r/CelebAssPussyMouth/comments/ei1vxg/natalie_... | Fuck Anne Hathaway, watch Amber, masturbate ov... | t3_ei1vxg | r/CelebAssPussyMouth | Wanchaiwarrior88 | 2020-01-01 05:54:33 | Negative | Negative | 2.0 | submission | comment | 8 | natalie_portman_anne_hattaway_and_amber_heard_sex | 8 | [] | 0 |
| 8 | t1_fctyubq | /r/pickoneceleb/comments/ei1w0i/natalie_portma... | Amber sex in pool\nWatch Natalie fuck herself ... | t3_ei1w0i | r/pickoneceleb | -banned- | 2020-01-02 11:58:06 | Negative | Neutral | 1.0 | submission | comment | 13 | natalie_portman_anne_hattaway_and_amber_heard_sex | 8 | [] | 0 |
| 31 | t1_fcznaxk | /r/celebJObuds/comments/ejmzgg/anyone_for_bige... | If any of these women suddenly grew a dick, I’... | t3_ejmzgg | r/celebJObuds | Chrazi87 | 2020-01-04 02:29:28 | Negative | Negative | 3.0 | submission | comment | 42 | anyone_for_bigenderplayfuta_fantasy_talk_with | 6 | [] | 0 |
| 38 | t1_fd0xess | /r/CelebrityArmpits/comments/ejhiq1/amber_hear... | Fuck it we're all a little crazy. So is Dep. | t1_fcxshw7 | r/CelebrityArmpits | TheGay666 | 2020-01-04 08:04:27 | Negative | Negative | 1.0 | comment | comment | 10 | amber_heard | 2 | [] | 0 |
f'{round(8468 / df.shape[0] * 100,2)} percent used f*ck work'
'6.59 percent used f*ck work'
# get the authors of these submissions having the same submission text
mask = (df['submission_text'] == 'fuck_amber_heard') & (df['submission_comment'] == 'submission')
df_sub = df[mask]
print(df_sub.shape)
with pd.option_context('display.max_colwidth', None):
display(df_sub.head())
(52, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5484 | t3_exsenw | /r/offmychest/comments/exsenw/fuck_amber_heard/ | Fuck Amber Heard | NaN | r/offmychest | shelbabyylynn | 2020-02-02 18:10:08 | Negative | Negative | 116.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
| 20859 | t3_ez0ci6 | /r/dankmemes/comments/ez0ci6/fuck_amber_heard/ | Fuck Amber Heard | NaN | r/dankmemes | -banned- | 2020-02-05 00:33:51 | Negative | Negative | 1.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
| 38463 | t3_f0xw8e | /r/POTCmemes/comments/f0xw8e/fuck_amber_heard/ | Fuck Amber Heard | NaN | r/POTCmemes | SlimandNone | 2020-02-08 21:17:38 | Negative | Negative | 1382.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
| 57338 | t3_fxa57h | /r/iamatotalpieceofshit/comments/fxa57h/fuck_amber_heard/ | Fuck Amber Heard! | NaN | r/iamatotalpieceofshit | -banned- | 2020-04-08 16:57:08 | Negative | Negative | 1.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
| 57340 | t3_fxa594 | /r/iamatotalpieceofshit/comments/fxa594/fuck_amber_heard/ | Fuck Amber Heard! | NaN | r/iamatotalpieceofshit | ManaStars | 2020-04-08 16:57:11 | Negative | Negative | 2021.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
# get the authors of these submissions having the same submission text
mask = (df['submission_text'].str.contains('fuck')) & (df['submission_comment'] == 'submission')
df_sub_fuc = df[mask]
print(df_sub_fuc.shape)
with pd.option_context('display.max_colwidth', None):
display(df_sub_fuc.head())
(235, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76 | t3_el50ij | /r/JerkOffToCelebs/comments/el50ij/amber_heard_begging_you_to_fuck_her_tight_pussy/ | Amber Heard begging you to fuck her tight pussy after seeing your large throbbing dick | NaN | r/JerkOffToCelebs | tayallen808 | 2020-01-07 02:48:28 | Negative | Negative | 27.0 | NaN | submission | 15 | amber_heard_begging_you_to_fuck_her_tight_pussy | 9 | [] | 0 |
| 83 | t3_el8igl | /r/JerkOffToCelebs/comments/el8igl/amber_heard_with_those_fuck_me_eyes/ | Amber Heard with those “fuck me” eyes. | NaN | r/JerkOffToCelebs | -banned- | 2020-01-07 07:54:18 | Negative | Neutral | 37.0 | NaN | submission | 7 | amber_heard_with_those_fuck_me_eyes | 7 | [] | 0 |
| 130 | t3_ems2vg | /r/JerkOffToCelebs/comments/ems2vg/how_roughly_would_you_throatfuck_amber_heard/ | How roughly would you throatfuck Amber Heard? | NaN | r/JerkOffToCelebs | flightfight1 | 2020-01-10 15:01:14 | Negative | Neutral | 68.0 | NaN | submission | 7 | how_roughly_would_you_throatfuck_amber_heard | 7 | [] | 0 |
| 137 | t3_emyakx | /r/celebJObuds/comments/emyakx/how_roughly_would_you_facefuck_amber_heard/ | How roughly would you facefuck Amber Heard? | NaN | r/celebJObuds | flightfight1 | 2020-01-10 22:25:04 | Negative | Neutral | 16.0 | NaN | submission | 7 | how_roughly_would_you_facefuck_amber_heard | 7 | [] | 0 |
| 407 | t3_etyhl3 | /r/JerkOffToCelebs/comments/etyhl3/amber_heard_is_my_dream_hate_fuck_whos_yours/ | Amber Heard is my dream hate fuck. Who’s yours? 😏 | NaN | r/JerkOffToCelebs | -GnarlyCharlie- | 2020-01-25 23:26:26 | Negative | Neutral | 73.0 | NaN | submission | 10 | amber_heard_is_my_dream_hate_fuck_whos_yours | 9 | [] | 0 |
we can see that this word appeared a lot in november after Depp loses his High Court libel action
df_fuc.author.value_counts().head(15)
-banned- 929 cracksniffer666 20 pacmatt27 19 AutoModerator 17 myIDateyourEGO 15 king_of_red_alphas 13 oTHEWHITERABBIT 12 FuckCoolDownBot2 12 Ryggg95 12 TheWizardChrist 11 akmetalhead 10 Doodle-DooDoo 10 azobran22 10 Usual_Class 10 immortalsperm 10 Name: author, dtype: int64
df_fuc.submission_comment.value_counts()
comment 8130 submission 338 Name: submission_comment, dtype: int64
df_fuc.subreddit.value_counts().head(10)
r/videos 1797 r/awfuleverything 598 r/entertainment 554 r/MensRights 525 r/pussypassdenied 522 r/JerkOffToCelebs 399 r/memes 351 r/iamatotalpieceofshit 350 r/TrueOffMyChest 193 r/AskReddit 146 Name: subreddit, dtype: int64
df_fuc
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | t1_fcou3a9 | /r/CelebAssPussyMouth/comments/ei1vxg/natalie_... | Fuck Anne Hathaway, watch Amber Heard, jack of... | t3_ei1vxg | r/CelebAssPussyMouth | azobran22 | 2020-01-01 01:19:48 | Negative | Negative | 2.0 | submission | comment | 11 | natalie_portman_anne_hattaway_and_amber_heard_sex | 8 | [] | 0 |
| 1 | t1_fcpccc4 | /r/CelebAssPussyMouth/comments/ei1vxg/natalie_... | Fuck Anne Hathaway, watch Amber, masturbate ov... | t3_ei1vxg | r/CelebAssPussyMouth | Wanchaiwarrior88 | 2020-01-01 05:54:33 | Negative | Negative | 2.0 | submission | comment | 8 | natalie_portman_anne_hattaway_and_amber_heard_sex | 8 | [] | 0 |
| 8 | t1_fctyubq | /r/pickoneceleb/comments/ei1w0i/natalie_portma... | Amber sex in pool\nWatch Natalie fuck herself ... | t3_ei1w0i | r/pickoneceleb | -banned- | 2020-01-02 11:58:06 | Negative | Neutral | 1.0 | submission | comment | 13 | natalie_portman_anne_hattaway_and_amber_heard_sex | 8 | [] | 0 |
| 31 | t1_fcznaxk | /r/celebJObuds/comments/ejmzgg/anyone_for_bige... | If any of these women suddenly grew a dick, I’... | t3_ejmzgg | r/celebJObuds | Chrazi87 | 2020-01-04 02:29:28 | Negative | Negative | 3.0 | submission | comment | 42 | anyone_for_bigenderplayfuta_fantasy_talk_with | 6 | [] | 0 |
| 38 | t1_fd0xess | /r/CelebrityArmpits/comments/ejhiq1/amber_hear... | Fuck it we're all a little crazy. So is Dep. | t1_fcxshw7 | r/CelebrityArmpits | TheGay666 | 2020-01-04 08:04:27 | Negative | Negative | 1.0 | comment | comment | 10 | amber_heard | 2 | [] | 0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 128269 | t1_ghkyy2x | /r/SubredditDrama/comments/knay25/rdc_cinemati... | Oh fuck. I forgot that dumpster fire exists. | t1_ghktnl1 | r/SubredditDrama | agutema | 2020-12-31 05:59:44 | Negative | Negative | 14.0 | comment | comment | 8 | rdc_cinematic_argues_over_amber_heard_being_in | 8 | [] | 0 |
| 128292 | t1_ghld487 | /r/SubredditDrama/comments/knay25/rdc_cinemati... | *laughs in Black Ops Cold War, with a nuclear ... | t1_ghky52k | r/SubredditDrama | ALDO113A | 2020-12-31 09:40:39 | Negative | Negative | -8.0 | comment | comment | 29 | rdc_cinematic_argues_over_amber_heard_being_in | 8 | [] | 0 |
| 128347 | t1_ghm996j | /r/asklatinamerica/comments/kno5sw/how_would_y... | It's not great, but I've heard worse. 6/10. Fu... | t3_kno5sw | r/asklatinamerica | Ponchorello7 | 2020-12-31 16:33:32 | Negative | Negative | 7.0 | submission | comment | 17 | how_would_you_rate_amber_heards_spanish_skills | 8 | [] | 0 |
| 128355 | t1_ghmhq7z | /r/SubredditDrama/comments/knay25/rdc_cinemati... | The movie logic was pretty fucking dumb throug... | t1_ghm8owu | r/SubredditDrama | everadvancing | 2020-12-31 17:45:57 | Positive | Positive | 8.0 | comment | comment | 45 | rdc_cinematic_argues_over_amber_heard_being_in | 8 | [] | 0 |
| 128398 | t1_ghndrst | /r/SubredditDrama/comments/knay25/rdc_cinemati... | How could you forget Birds of Prey and the fan... | t1_ghms3r1 | r/SubredditDrama | Finito-1994 | 2020-12-31 22:33:35 | Negative | Negative | 0.0 | comment | comment | 25 | rdc_cinematic_argues_over_amber_heard_being_in | 8 | [] | 0 |
8468 rows × 17 columns
df_fuc.created_at.dt.date.value_counts().to_frame().reset_index().rename(columns={'index': 'date',
'created_at': 'n_contributions'})
| date | n_contributions | |
|---|---|---|
| 0 | 2020-02-04 | 701 |
| 1 | 2020-11-07 | 486 |
| 2 | 2020-02-08 | 421 |
| 3 | 2020-02-02 | 396 |
| 4 | 2020-02-07 | 330 |
| ... | ... | ... |
| 325 | 2020-03-13 | 1 |
| 326 | 2020-07-06 | 1 |
| 327 | 2020-01-19 | 1 |
| 328 | 2020-09-16 | 1 |
| 329 | 2020-10-08 | 1 |
330 rows × 2 columns
fig = px.bar(df_fuc.created_at.dt.date.value_counts().to_frame().reset_index().rename(columns={'index': 'date',
'created_at': 'n_contributions'}),
x='date',
y='n_contributions', title='The number of submissions with the word "F*CK" in 2020')
fig.update_traces(marker_color='red', marker_line_width=0.5, opacity=1, textposition='auto')
# , marker_line_color='#5296dd'
fig.show()
df_fuc.created_at.dt.date.value_counts().head(10)
2020-02-04 701 2020-11-07 486 2020-02-08 421 2020-02-02 396 2020-02-07 330 2020-02-05 328 2020-12-16 287 2020-02-09 260 2020-02-06 247 2020-11-08 236 Name: created_at, dtype: int64
df_fuc.author.value_counts().head(10)
-banned- 929 cracksniffer666 20 pacmatt27 19 AutoModerator 17 myIDateyourEGO 15 king_of_red_alphas 13 oTHEWHITERABBIT 12 FuckCoolDownBot2 12 Ryggg95 12 TheWizardChrist 11 Name: author, dtype: int64
df_fuc.submission_comment.value_counts()
comment 8130 submission 338 Name: submission_comment, dtype: int64
df_fuc.subreddit.value_counts().head(10)
r/videos 1797 r/awfuleverything 598 r/entertainment 554 r/MensRights 525 r/pussypassdenied 522 r/JerkOffToCelebs 399 r/memes 351 r/iamatotalpieceofshit 350 r/TrueOffMyChest 193 r/AskReddit 146 Name: subreddit, dtype: int64
df_fuc_contributions = df_fuc.groupby(df_fuc.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_fuc_contributions,
x='created_at',
y='n_contributions', title='The number of "F*CK" contributions in 2020')
fig.update_traces(marker_color='red', marker_line_width=0.5, opacity=1, textposition='auto')
# , marker_line_color='#5296dd'
fig.show()
df_fuc_contributions.sort_values('n_contributions', ascending=False).head(10)
| created_at | n_contributions | |
|---|---|---|
| 21 | 2020-02-04 | 701 |
| 275 | 2020-11-07 | 486 |
| 25 | 2020-02-08 | 421 |
| 19 | 2020-02-02 | 396 |
| 24 | 2020-02-07 | 330 |
| 22 | 2020-02-05 | 328 |
| 314 | 2020-12-16 | 287 |
| 26 | 2020-02-09 | 260 |
| 23 | 2020-02-06 | 247 |
| 276 | 2020-11-08 | 236 |
used the word f*ck 20 times
Negative Comments
df_cracksniffer666 = df.query(" author == 'cracksniffer666' ")
print(df_cracksniffer666.shape)
df_cracksniffer666.head()
(99, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43684 | t3_f1gjcu | /r/fakehistoryporn/comments/f1gjcu/amber_heard... | Amber Heard, preparing to frame Johnny Depp, 2017 | NaN | r/fakehistoryporn | cracksniffer666 | 2020-02-09 22:42:34 | Neutral | Neutral | 36851.0 | NaN | submission | 8 | amber_heard_preparing_to_frame_johnny_depp_2017 | 8 | [] | 0 |
| 43890 | t1_fh6hsa8 | /r/fakehistoryporn/comments/f1gjcu/amber_heard... | She cut off his finger, shit in his bed, and w... | t1_fh6gtos | r/fakehistoryporn | cracksniffer666 | 2020-02-10 01:45:16 | Negative | Negative | 742.0 | comment | comment | 30 | amber_heard_preparing_to_frame_johnny_depp_2017 | 8 | [] | 0 |
| 43961 | t1_fh6s1s7 | /r/fakehistoryporn/comments/f1gjcu/amber_heard... | Explain | t1_fh6qdmw | r/fakehistoryporn | cracksniffer666 | 2020-02-10 03:18:24 | Neutral | Neutral | 8.0 | comment | comment | 1 | amber_heard_preparing_to_frame_johnny_depp_2017 | 8 | [] | 0 |
| 43969 | t1_fh6tb6r | /r/fakehistoryporn/comments/f1gjcu/amber_heard... | That's pathetic | t1_fh6pk4d | r/fakehistoryporn | cracksniffer666 | 2020-02-10 03:32:41 | Negative | Negative | 103.0 | comment | comment | 2 | amber_heard_preparing_to_frame_johnny_depp_2017 | 8 | [] | 0 |
| 44020 | t1_fh6wq1t | /r/fakehistoryporn/comments/f1gjcu/amber_heard... | Username checks out. No. No we can't. | t1_fh6vq0j | r/fakehistoryporn | cracksniffer666 | 2020-02-10 04:14:19 | Neutral | Negative | 31.0 | comment | comment | 7 | amber_heard_preparing_to_frame_johnny_depp_2017 | 8 | [] | 0 |
df_cracksniffer666.groupby(df_cracksniffer666.created_at.dt.date).size().reset_index(name='n_contributions')
| created_at | n_contributions | |
|---|---|---|
| 0 | 2020-02-09 | 1 |
| 1 | 2020-02-10 | 89 |
| 2 | 2020-07-03 | 6 |
| 3 | 2020-07-04 | 3 |
df_cracksniffer666.text.value_counts().head(3)
I'm just scared knowing people upvoted you thinking you were serious. 1 Go look at the pinned post on my profile.... Lol 1 I know if I raised a baby girl for 18 years and saw her ass on the internet, I'd be internally sad. The end. Agree to disagree I guess. 1 Name: text, dtype: int64
df_cracksniffer666[df_cracksniffer666.created_at.dt.date == datetime.date(2020, 2, 10)].text.values
array(['She cut off his finger, shit in his bed, and would paint bruises on herself to claim abuse from him. A piece of shit. Society is still defending her also.',
'Explain', "That's pathetic",
"Username checks out. No. No we can't.", 'Yeah haha',
"The media is still praising her. Don't believe what you hear. There's still people defending her also. Listen to the therapy tapes... That's all I'll tell you",
'Preach.', "It's fucked",
"You're a misogynist for thinking she should be treated as a man would. What world do you live in? EQUALITY.",
'Yeah, search anywhere for like 5 mins',
'Nobody here, lol.. You\'re mentally unstable if you\'re defending reddit lol. There are plenty of people that have defended her, or used the classic "deflection" technique, saying "OH, WELL, WHAT DID HE DO TO MAKE HER DO THAT?!" No. No. Get the fuck on outta here with that shit. She got caught being a piece of shit abuser, and now you\'re all gonna see it.',
"Username checks out, once again. Women are more than 5 times more likely to defend and protect women, no matter the cost, what the woman did, etc. Here's an actual study for you! https://www.apa.org/monitor/dec04/women",
'Yes. and cut his fucking finger off. or at least the tip. Her on those tapes, degrading him "OH, JOHNNY, no ones ever gonna believe you about the abuse!" that was worse than any of it to me. Just gaslighting the poor dude. She put a lit cigarette out on his face too. Look that picture up.',
'Yeah, we have to work sex into it somehow, I forgot reddit obsessed about mating... lol jesus.. Get a hobby',
'google her name. Simply.',
'I\'ve had 3 or 4 people "go against" what I\'m saying, and they all had weird pixie/witchy/feminine usernames. It\'s truly sad. When do you finally admit you gender can do wrong, as we\'re all human? Living life on easy mode.',
"Prob won't happen. Which will give the green light to more women aggressors, why do they not see this ending in chaos eventually? The only reason I posted this, is because I was abused, SHE went to jail, and I still lost all my friends from her bullshit lies. SOCIETY NEEDS TO WAKE UP. To think men are so awful, when we're the exact same species as women, is hilarious. Stop giving them the pass to be awful. It's just gotten sad at this point. On another note, I couldn't imagine going to my daughter's Instagram, and seeing her ass. Wtf happened?.......",
'There was a literal movement about it, you clown. #metoo. Why are people hardwired to neglect abused men? Seriously ask yourself.',
'Comment on the wrong person, my bad',
"Why are you winking, on an abuse thread? Is a smiley wink okay if a man abuses someone, just to make your argument valid? You're fucking gross.",
"I've been in love, and drunkenly defended her. I don't even believe what he's saying, love can fuck you up. He's definitely not told it all, and other crazy stuff she has done.. My ex went to jail twice and no one believed me so, yeah..",
'Le inkwell*!!!! 1',
"So you'd get beat up, have your career ruined, and be mentally tortured, for pussy? I hope you work alone, because I can't see women or men respecting you.. That's just gross",
'Asscrack',
'Still got screwed in the end.. Lost most of my friends. It\'s called "reputation destruction" and its common now with social media. The modern chicks I know are extremely vindictive.. :(',
'Say something bad about her then.',
'Maybe I\'ll meme the Elon musk thing next, since women can do no wrong on reddit. I HAVE TO ASK.... do dudes that blindly defend women on here, think they\'re gonna get laid, by a random, anynomous person? I\'ve never understood that. Is it cognitive dissonance? "well, I defended m\'lady, now I can sleep soundly tonight..." like I literally don\'t know what their main objective is.. I respect my mother, my sister, and the couple chicks I hangout wit/hook up with, and I can\'t see blindly defending someone if they\'re wrong.. My mind just can\'t do it. I\'m glad these Neckbeards aren\'t attourneys/judges... Fuck..',
'Lies? Women can be awful, too. Either say yes, I agree, or piss off. We\'re aware men can be awful. The past 10 years of Twitter has proven that, but; I want you to say, "women can be awful too" and I\'ll respect you, and listen to what you have to say. I dare you.',
"Wait, Johnny Depp isn't at fault.", 'Fuck Chris brown too.',
"It's not a fucking gender thing you Goddamn pussy panderers",
'Let me Know when Princess Peach is the plumber instead of Mario.',
"Are you saying shit bounced? Either you're a great troll, or you need counseling. I feel like I'm being fucked with, but I AM on reddit, so who knows",
'Hahahahahah',
'Doubts. My Answer is no. Probably get another movie deal knowing Hollywood.',
"You're wrong dude! Not everyone thinks women can be shitty! Stop projecting. Women defend women 5x more than they would defend a man for the same thing.",
"Classic shaming, I'm fragile, but you're the one who feels the need to comment to a stranger and tell him who, and what he is..lol. Okay",
'Damn those 20k upvotes and my weird agenda! Blasted!', 'True',
'Yeah because this has everything to do with a crazy man. Fuck off.',
"A worm. I've fell victim to beautiful women before, and it's literally the same thing as a venus fly trap. Just no. Women are beautiful because of biology. If they weren't, we wouldn't be here. But some people try to manipulate others with that advantage. Not cool.",
'Deal. Lol',
'What I\'m trying to PROVE, is that Reddit, among other things, aimlessly defend women, no matter the story. You can\'t seem to see that though. I\'m a fucktard. I have 70 IQ and am not worthy to talk to you :( This has everything to do with gender, in this situation. If Depp did this, and there were tapes released, he\'d be in jail. "Amber Heard just seen out with new girlfriend after Johnny Depp audio scandal" Seriously? Google "Amber Heard" and see how they\'re portraying it. WTF is wrong with your brain. Google that, and then IMMEDIATELY listen to the FUCKING ACTUAL AUDIO and form YOUR OWN opinion? Good fucking god, I feel like I\'m going crazy. Just google her and see what the tabloids aren\'t saying. Good luck.',
"It's sad that healthy, lovely, young women and men are getting shown this shit. It truly upsets me, and I'm scared to have children at this point. If I have a son, I have to worry, if I have a daughter, I have to worry twice as much. Just doesn't seem worth it, wish we could hit the 90s one more time, lol",
'Lol. Is the chocolate chip cookie a recipe or an invention?',
"They're video games... Lol. Idk what you want anymore. You broke up with me 3 years ago and now try to comment here...",
'Hahahaha gotcha bitch!', 'Tell me why, and I might',
"You need mental help. Youve been indoctrinated, person.. Please explain how I've objectifed anyone, without sounding like and idiot, and/or deleting your comments. Go.",
'Stop saying stuff like that man',
"It's reality.. Lemons haven't evolved? Wolves didn't become man's best friend? Allright, let's just leave out the most intelligent species on the planet, no evolution or adaption there. You're right. - ____-",
"I don't believe in canceling people. She should go to kangaroo court.",
'5 out of 5 today. Username checks out. I have nothing to say to your superficial ass, lmao',
"Bruh, it's fake history porn. The subreddit. It's a joke, playing off of something that happened... Lol damn you must be faded like ya boi",
'Nice.',
'He was late to her birthday party, I heard, and she placed the shit in the bed.',
"Who? I've suffered from domestic violence. Act surprised",
"Lol lackey... Haha. I'm sorry a group of dudes have found out it's not worth it to lose our houses, kids, etc. Boohoo, u mad?",
"But seriously; are you gonna cry that men have literally one space to chat? I'm assuming you're a low value boring human, rummaging through posts.. Check out femaledatingstrategy or pink pill feminism. Id bet 100 bucks I don't hear back from you after looking there. GL!",
"It's crazy you can have a driver's license and vote. I hope the rest of your life is easy as it is now sweetheart..",
"You're a weird lonely troll most likely.", 'Zombieland 2009',
'Feel free to come on my podcast and air it out',
"Dude some humans aren't ready for the truth and it scares me.. Like dude.. We're past that point. Lol. We know we're animals, we mate, procreate, etc. Some people still look at life like a fucking Disney movie, as an adult, lol. Cmon now. We're mammals. But trickier.",
'Log onto Instagram and follow any chick lol',
"Still passing through that storm. Been 3 years. I used to want to call her, and then I'd Google her mugshot. Fuck dat.",
'From what I read, he was late for her birthday party, and she shat, and put it in the bed. I had a hard time believing it, until I heard their therapy sessions.',
'If you\'re being abused, whatever gender you are, reach out to me, or someone you trust. Do not let yourself be gaslighted into abuse. I\'ll call you or get you a number to call, if you feel like your "partner" is treating you wrong. Real shit. DM me.',
"It's really fucking sad, and this post has blown up, I'd rather just go on to bed.. Fuck. I'm staying awake to defend Johnny of the insanity, but I'm going insane myself doing so. Cheers. Thank you.",
'Welp, good morning, holy fuck this shit blew up lol',
"Modern women mentality, yes. I don't hate my mother, or little sister. But yes.",
'Wait until you hear about Jesus', 'Thank you',
"I know. I'm a traditional guy. Thank you for reminding me of that and giving me a shred of hope. Lol things have gotten different...",
"Same here, I got Ya back. It ain't easy.", 'Lmao!',
'Female own group preference', 'She chose that route. Sad.',
'She probably is, sadly. This is the world we created.',
"Show me where I said I wasn't an asshole. I'm honest. Women defend other women, no matter the situation. You want me to link your stupid ass the study also? I can! \n\nIn short, yes, I am being attacked by women, all of them had similar usernames. Go look! It's in front of you. [https://www.apa.org/monitor/dec04/women](https://www.apa.org/monitor/dec04/women)",
"No way... You could see him in Edward Scissor Hands, and just know how innocent of a dude that is.. Poor dude. Love will fuck a man's head up, for sure. It has mine.",
"Thank you for actually providing a decent argument and showing me how I'm wrong on certain points. That's what I came here for, 7 years ago, and it's rare now. Cheers. I'll try. Everyone has their own story. I'll try to better my ending.",
"You're right. Thanks for being cool about it",
"I can rightfully nod to that. I'm dancing at the moment lol sorry",
"What I want to do, is blame him for not walking away, but ladies and men both know, when you got that TRUE LOVE for someone, (or so you think) it's like a fucking drug, and you aren't rational. That's why I give some people a little leeway when it comes to relationships, because love is the strongest drug in the fucking world, and people play with it like it's candy cigarettes",
'Same, I disappeared from FB 3 years ago.. it sucks to miss out on shit, but.. I need my mental health lol. Hit me up if you ever wanna talk, you seem chill',
"I'm just scared knowing people upvoted you thinking you were serious.",
"I know if I raised a baby girl for 18 years and saw her ass on the internet, I'd be internally sad. The end. Agree to disagree I guess.",
'I had to.'], dtype=object)
df_users[df_users.user_name == 'cracksniffer666']
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 68387 | cracksniffer666 | True | True | True | True | NaN | NaN | NaT | banned | banned |
sum(sum([df_cracksniffer666[df_cracksniffer666.text.str.contains('fuck')].created_at.dt.date == datetime.date(2020, 2, 10)]).values)
13
suspected_dict['cracksniffer666'] = 'Created at:uknown date, used the word f*ck in 13 negative comments in FEB 10 2020'
suspected_dict
{'cracksniffer666': 'Created at:uknown date, used the word f*ck in 13 negative comments in FEB 10 2020'}
df_cracksniffer666_contributions = df_cracksniffer666.groupby(df_cracksniffer666.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_cracksniffer666_contributions,
x='created_at',
y='n_contributions', title='The number of "cracksniffer666" contributions in 2020')
fig.update_traces(marker_color='red', marker_line_width=2, opacity=1, textposition='auto')
fig.show()
89 in 10 feb 2020!
for i in df_cracksniffer666[~df_cracksniffer666.text.str.contains('fuck')].text.values:
print(i)
Amber Heard, preparing to frame Johnny Depp, 2017 She cut off his finger, shit in his bed, and would paint bruises on herself to claim abuse from him. A piece of shit. Society is still defending her also. Explain That's pathetic Username checks out. No. No we can't. Yeah haha The media is still praising her. Don't believe what you hear. There's still people defending her also. Listen to the therapy tapes... That's all I'll tell you Preach. You're a misogynist for thinking she should be treated as a man would. What world do you live in? EQUALITY. Yeah, search anywhere for like 5 mins Username checks out, once again. Women are more than 5 times more likely to defend and protect women, no matter the cost, what the woman did, etc. Here's an actual study for you! https://www.apa.org/monitor/dec04/women Yeah, we have to work sex into it somehow, I forgot reddit obsessed about mating... lol jesus.. Get a hobby google her name. Simply. I've had 3 or 4 people "go against" what I'm saying, and they all had weird pixie/witchy/feminine usernames. It's truly sad. When do you finally admit you gender can do wrong, as we're all human? Living life on easy mode. Prob won't happen. Which will give the green light to more women aggressors, why do they not see this ending in chaos eventually? The only reason I posted this, is because I was abused, SHE went to jail, and I still lost all my friends from her bullshit lies. SOCIETY NEEDS TO WAKE UP. To think men are so awful, when we're the exact same species as women, is hilarious. Stop giving them the pass to be awful. It's just gotten sad at this point. On another note, I couldn't imagine going to my daughter's Instagram, and seeing her ass. Wtf happened?....... There was a literal movement about it, you clown. #metoo. Why are people hardwired to neglect abused men? Seriously ask yourself. Comment on the wrong person, my bad Le inkwell*!!!! 1 So you'd get beat up, have your career ruined, and be mentally tortured, for pussy? I hope you work alone, because I can't see women or men respecting you.. That's just gross Asscrack Still got screwed in the end.. Lost most of my friends. It's called "reputation destruction" and its common now with social media. The modern chicks I know are extremely vindictive.. :( Say something bad about her then. Maybe I'll meme the Elon musk thing next, since women can do no wrong on reddit. I HAVE TO ASK.... do dudes that blindly defend women on here, think they're gonna get laid, by a random, anynomous person? I've never understood that. Is it cognitive dissonance? "well, I defended m'lady, now I can sleep soundly tonight..." like I literally don't know what their main objective is.. I respect my mother, my sister, and the couple chicks I hangout wit/hook up with, and I can't see blindly defending someone if they're wrong.. My mind just can't do it. I'm glad these Neckbeards aren't attourneys/judges... Fuck.. Lies? Women can be awful, too. Either say yes, I agree, or piss off. We're aware men can be awful. The past 10 years of Twitter has proven that, but; I want you to say, "women can be awful too" and I'll respect you, and listen to what you have to say. I dare you. Wait, Johnny Depp isn't at fault. Fuck Chris brown too. Let me Know when Princess Peach is the plumber instead of Mario. Hahahahahah Doubts. My Answer is no. Probably get another movie deal knowing Hollywood. You're wrong dude! Not everyone thinks women can be shitty! Stop projecting. Women defend women 5x more than they would defend a man for the same thing. Classic shaming, I'm fragile, but you're the one who feels the need to comment to a stranger and tell him who, and what he is..lol. Okay Damn those 20k upvotes and my weird agenda! Blasted! True Yeah because this has everything to do with a crazy man. Fuck off. A worm. I've fell victim to beautiful women before, and it's literally the same thing as a venus fly trap. Just no. Women are beautiful because of biology. If they weren't, we wouldn't be here. But some people try to manipulate others with that advantage. Not cool. Deal. Lol It's sad that healthy, lovely, young women and men are getting shown this shit. It truly upsets me, and I'm scared to have children at this point. If I have a son, I have to worry, if I have a daughter, I have to worry twice as much. Just doesn't seem worth it, wish we could hit the 90s one more time, lol Lol. Is the chocolate chip cookie a recipe or an invention? They're video games... Lol. Idk what you want anymore. You broke up with me 3 years ago and now try to comment here... Hahahaha gotcha bitch! Tell me why, and I might You need mental help. Youve been indoctrinated, person.. Please explain how I've objectifed anyone, without sounding like and idiot, and/or deleting your comments. Go. Stop saying stuff like that man It's reality.. Lemons haven't evolved? Wolves didn't become man's best friend? Allright, let's just leave out the most intelligent species on the planet, no evolution or adaption there. You're right. - ____- I don't believe in canceling people. She should go to kangaroo court. 5 out of 5 today. Username checks out. I have nothing to say to your superficial ass, lmao Bruh, it's fake history porn. The subreddit. It's a joke, playing off of something that happened... Lol damn you must be faded like ya boi Nice. He was late to her birthday party, I heard, and she placed the shit in the bed. Who? I've suffered from domestic violence. Act surprised Lol lackey... Haha. I'm sorry a group of dudes have found out it's not worth it to lose our houses, kids, etc. Boohoo, u mad? But seriously; are you gonna cry that men have literally one space to chat? I'm assuming you're a low value boring human, rummaging through posts.. Check out femaledatingstrategy or pink pill feminism. Id bet 100 bucks I don't hear back from you after looking there. GL! It's crazy you can have a driver's license and vote. I hope the rest of your life is easy as it is now sweetheart.. You're a weird lonely troll most likely. Zombieland 2009 Feel free to come on my podcast and air it out Log onto Instagram and follow any chick lol Still passing through that storm. Been 3 years. I used to want to call her, and then I'd Google her mugshot. Fuck dat. From what I read, he was late for her birthday party, and she shat, and put it in the bed. I had a hard time believing it, until I heard their therapy sessions. If you're being abused, whatever gender you are, reach out to me, or someone you trust. Do not let yourself be gaslighted into abuse. I'll call you or get you a number to call, if you feel like your "partner" is treating you wrong. Real shit. DM me. Modern women mentality, yes. I don't hate my mother, or little sister. But yes. Wait until you hear about Jesus Thank you I know. I'm a traditional guy. Thank you for reminding me of that and giving me a shred of hope. Lol things have gotten different... Same here, I got Ya back. It ain't easy. Lmao! Female own group preference She chose that route. Sad. She probably is, sadly. This is the world we created. Show me where I said I wasn't an asshole. I'm honest. Women defend other women, no matter the situation. You want me to link your stupid ass the study also? I can! In short, yes, I am being attacked by women, all of them had similar usernames. Go look! It's in front of you. [https://www.apa.org/monitor/dec04/women](https://www.apa.org/monitor/dec04/women) Thank you for actually providing a decent argument and showing me how I'm wrong on certain points. That's what I came here for, 7 years ago, and it's rare now. Cheers. I'll try. Everyone has their own story. I'll try to better my ending. You're right. Thanks for being cool about it I can rightfully nod to that. I'm dancing at the moment lol sorry Same, I disappeared from FB 3 years ago.. it sucks to miss out on shit, but.. I need my mental health lol. Hit me up if you ever wanna talk, you seem chill I'm just scared knowing people upvoted you thinking you were serious. I know if I raised a baby girl for 18 years and saw her ass on the internet, I'd be internally sad. The end. Agree to disagree I guess. I had to. Go look at the pinned post on my profile.... Lol Daddy wasn't there, or daddy never told them "no". Same people defending m'females, are the same people who mock "Karen", but never go into the psychological reasoning of why these women end up extremely entitled/devoid of reality. Part of the problem. Don't have kids. Not that a reasonable woman would let you cum inside of her, but yeah. Or, people could Google "female own group preference" and be better off accepting the truth. Found the founder ​ See how dumb that sounds/feels? It's like, we're here (most of us, somewhat intelligent people) for decent discussion, not an easter egg hunt of people you don't like. When ever someone says "found the X" I just imagine a 3 year old fitting a circle block into a circular hole. YAAAYYY I DEED ITTT! You're better than that. lmfao 'NEXT WEEK, ON INCEL POLICE FORCE: REDDIT'
the rest of contributions are also negative
used the word f*ck 19 times
Negative Comments
df_pacmatt27 = df.query(" author == 'pacmatt27' ")
print(df_pacmatt27.shape)
df_pacmatt27.head()
(104, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95925 | t1_gbgqrp7 | /r/MensRights/comments/jprmy5/petition_to_have... | Just curious how you can identify with a movem... | t1_gbgk64v | r/MensRights | pacmatt27 | 2020-11-07 16:29:05 | Negative | Neutral | 38.0 | comment | comment | 16 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 95926 | t1_gbgqs10 | /r/MensRights/comments/jprmy5/petition_to_have... | Just curious how you can identify with a movem... | t1_gbglcnj | r/MensRights | pacmatt27 | 2020-11-07 16:29:09 | Negative | Neutral | -3.0 | comment | comment | 16 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 95992 | t1_gbgsjai | /r/MensRights/comments/jprmy5/petition_to_have... | No, they're not and it's not a strong term. Fe... | t1_gbgryj9 | r/MensRights | pacmatt27 | 2020-11-07 16:42:21 | Positive | Neutral | 23.0 | comment | comment | 75 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 96000 | t1_gbgsr40 | /r/MensRights/comments/jprmy5/petition_to_have... | I asked it of two people who proclaimed their ... | t1_gbgru7m | r/MensRights | pacmatt27 | 2020-11-07 16:43:57 | Neutral | Negative | 11.0 | comment | comment | 30 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
| 96002 | t1_gbgsvil | /r/MensRights/comments/jprmy5/petition_to_have... | Egalitarian. | t1_gbgrpz2 | r/MensRights | pacmatt27 | 2020-11-07 16:44:45 | Neutral | Neutral | 17.0 | comment | comment | 1 | petition_to_have_amber_heard_removed_as_the | 8 | [] | 0 |
df_pacmatt27.groupby(df_pacmatt27.created_at.dt.date).size().reset_index(name='n_contributions')
| created_at | n_contributions | |
|---|---|---|
| 0 | 2020-11-07 | 94 |
| 1 | 2020-11-08 | 8 |
| 2 | 2020-11-15 | 1 |
| 3 | 2020-11-17 | 1 |
df_pacmatt27.text.value_counts().head(3)
Please do. 2 Just curious how you can identify with a movement which has essentially become a hate group? 2 K, bye. 2 Name: text, dtype: int64
df_pacmatt27[df_pacmatt27.created_at.dt.date == datetime.date(2020, 11, 7)].text.values
array(['Just curious how you can identify with a movement which has essentially become a hate group?',
'Just curious how you can identify with a movement which has essentially become a hate group?',
"No, they're not and it's not a strong term. Feminists permit the spread of an ideology that openly treats men as hostile entities and pushes an agenda of securing more and more power and privilege for women while removing it for men. If you identify yourself as a feminist you are suggesting that you are accepting of that agenda. You, as an individual, may be interested in equality but that is not what feminism is.",
"I asked it of two people who proclaimed their identification with the group. If you can't tolerate questions on it and get defensive when you receive them, that's your problem.",
'Egalitarian.',
'Not sure how to phrase that question more simply.',
">Feminism is not man hating\n\nThat's an interesting point of view, considering all of the terminology and theory is set up to paint men as the enemy and women as the heroes (or victims, they seem quite confused on whether women are powerful or weak). The clue is in the name, feminism. For more examples see: patriarchy, toxic masculinity, rape culture, mansplaining/manspreading.\n\nBLM also has a very large white-hating component but whatever, this isn't about race.\n\n>To conflate feminism with man hate, or misandry, exhibits a fundamental misunderstanding of what woman have fought for.\n\nNo, it doesn't. They have fought for protections and privileges which men are denied, legal rights which men do not have, unfair treatment across a wide range of contexts and give little to no attention to male issues (when they aren't actively suppressing those issues). There is nothing equal about feminism and you're delusional if you think that's what feminism seeks.",
"No, it still makes sense, you just don't agree.", 'Please do.',
"I am not. I have done. Those sub-sections who are for genuine equality are complete non-entities as far as political and social change are concerned.\n\nWhat is frequently used to divide groups? Calling a spade a spade? I don't think so. If we are going to be subjected to laws and social policies, fought for by feminism, which put men at a significant disadvantage, I will ask why feminism is not interested in equality. \n\nWhy divide? What a stupid question. Feminism is literally about division and conflict between genders. I am asking why someone would subscribe to a divisive ideology instead of pursuing genuine equality.\nThe rest of what you said is totally irrelevant. I am not American, I am not interested in Mexican immigrants or job automation, the GOP or Wall Street and I am not right-wing.",
"No, it's not, you patronising wank.\n\nI work in psychology which is female-dominated and is full of self-proclaimed feminists. I used to be a feminist and stopped because they blatantly weren't interested in equality. No feminist movements focus on male issues, they just bleat on about the same, tired, misinformed bullshit which pale in comparison to a lot of male issues.",
'You may not consider them feminists but they constitute the power and backbone of your movement. They\'re the ones who influence legal and social change. If you say you\'re a feminist, you admit complicity with those individuals. Also, how can you be a feminist without subscribing to patriarchy theory, exactly, and all that it entails?\n\nAnd the thing is, you say they\'re not real feminists, but they are. They hold the ideals feminism has always held. At its heart, feminism is a female advocacy movement and has no interest in genuine equality, it never did. It has always operated on the assumption that men hold power and use it to oppress women. Over the years it has added "and sometimes men" but done nothing about that. It\'s a throwaway acknowledgement to appear egalitarian rather than any genuine interest.',
"Why not start with reproductive rights? Women have access to state-provided birth control in many countries, they have the right to terminate pregnancies, give children up for adoption and face no consequences, they can commit paternity fraud with no repercussions or refuse to notify the father. Men have absolutely no such rights.\n\nUntil recently women had the right to automatically be granted custody of children. Since the change they still receive preferential treatment in custody disputes (though admittedly not a legal right anymore). Women receive preferential treatment in all legal matters, while we're on the subject. Less likely to be arrested, charged, found guilty and sentenced for comparable crimes, shorter sentences when they are.\n\nWomen in certain countries are automatically assumed to be the victim in domestic violence disputes, despite evidence clearly demonstrating that is not representative of actuality.\n\nI could go on for a while but I've got a stats project to do, so will that be sufficient for the time being?\n\nSo do I. I just disagree that feminism is a force for good in any way. I would argue that it has achieved its purpose, exceeded its purpose and now serves to advance inequalities in favour of women.",
"I don't associate with them because many elements are hateful. I do not label myself as a men's rights activist, I'm an egalitarian. It makes perfect sense.",
"Women have equal rights though. And they have more rights than men. Feminism is and always has been a female advocacy movement. I can see that as a necessity in past decades but I don't see why someone would identify with it now if they genuinely wanted equality. \n\nIt's becoming more and more clear that prominent feminists want women to feel weak and frightened, not powerful and strong. They want to make everything a victimisation and an oppression, to avoid becoming irrelevant. To take no responsibility and demand more benefits, to change men and do nothing... To become passive.\n\nI'm 30 so I'm not a wee lad anymore either. I grew up seeing powerful women in my favourite films and not once did they claim to be oppressed and that the world change for them. They just strapped themselves into a mech, or picked up a shotgun, and shot the world in the face. I can't see Ellen Ripley crying and claiming she's oppressed.",
">“Same, tired, misinformed bullshit” sounds a lot like a person making a decision on the entirety of a thing from a very small sample size. \n\nNo, it sounds like an assessment of high-profile feminist talking points from my perspective.\n\n>This one case is not indicative that women lie about abuse. The stats don’t support that women often lie about abuse.\n\nNo, false reporting statistics suggest that people lie about crimes on a regular enough basis that we need to be careful about prosecution, slander and libel.\n\n>Besides, if you’re just going to bitch that people are focused on issues that affect them and not issues that affect you, while only being focused on issues that affect you, you’re being pretty damn hypocritical.\n\nI'm not *only* focused on issues that affect me. Where the hell have you got that from?",
">There are still some legitimate areas where women don't have equality.\n\nWhich? I'm not saying there aren't but I am a little curious on where you feel women do not have equality. Many of the common talking points are not as straight-forward as they appear.\n\n> It's a difficult problem, how do you push for equality in those remaining areas without legitimizing the bad parts of modern feminism? \n\nI'd start by not approaching it from a feminist perspective. Their ideology is just so, a political, sociological ideology, with no legitimacy as a scientific construct. It should not be used to inform social or legal policy.",
"> There are multiple different branches of Feminism.\n\nPlease don't patronise me. I'm more than aware of that. \n\n>The type you're probably referring to is radical feminism which is more anarchist in nature.\n\nWrong, I am referring to mainstream third wave feminism, which is the most popular form of feminism at present.\n\n>Most Feminists you'll meet in real life literally just want equity for genders\n\nWrong. Most feminists I meet in real life are hypocrites with a startling lack of awareness of male issues, an inability to react to dissent rationally and a spiteful, greedy, vengeful victim complex.\n\n>Anti-men feminists are the exception, not the rule.\n\nWrong and, even if they were, they are not the ones informing social and legal policy and lack the power to do anything meaningful.",
'>There are plenty of feminists that aren\'t extremists.\n\nNot anymore.\n\n>I suggest we all try moving away from this "feminazi" narrative and realise we\'re all working towards the same goal.\n\nI\'d love to, if that were true.',
"Lmfao, no it isn't, get a grip.",
"I don't think all women are. I think most women are fairly normal, like most men. Some are arseholes and some are sound.\n\nFeminists, I'd say, are largely tossers - male or female. \n\nNice try though, now fuck off.",
'That\'s fun. What are you doing to eradicate toxic gender norms perpetrated by women? What are you doing to eradicate toxic behaviours perpetrated by women? Could you even tell me what those are, out of curiosity? Because no feminist I\'ve ever asked has been able to.\n\nCos, and correct me if I\'m wrong here, what it *seems* like you\'re doing is actually behaving like every agent in the world is somehow a representative of the patriarchy, hellbent on oppressing women. Films, games, television, science, technology, the law, even Terry the bus driver. Not only this, it also seems like feminism suggests that women (or, more specifically, women who agree with you) don\'t actually have to do anything to change this. All they have to do is tell men to change and then the men need to do whatever you say. The only problem with that is those rules are so unclear, convoluted and irrational that it\'s literally impossible to abide by them. So men are, wittingly or no, constantly subjecting women to micro-aggressions and toxicity and women are constantly trapped in a victim role but somehow powerful lionesses. What an appealing image "I can do no wrong and others hold me back from my true potential".\n\nWhat on earth would the point of that be? Would it... Perhaps... Be to sell more books, get more funding from academic and social institutions and to remain relevant long after equality has been achieved by creating a false dichotomy of oppressed/oppressor? OMG IT WOULD.\n\nYeah, no thanks. Gender norms are actually pretty useful in certain instances. That\'s why gender dysphoria is increasing, as is the suicide and mental illness rate.',
"I can't m8, covid-19.",
"I can be dismissed like that if you're too cowardly to engage me, sure. It doesn't bother me because I know I'm right. And, contrary to popular belief, being right (not what you feel) is what matters.",
'K. Make sure you leave your feminist theory at the door!',
"You do know that in all of those countries men face similar issues, right? It's not because of sexism, it's because those countries are shitholes.",
"Denser, now shut up and listen to your betters. \n\n>Please show me where in the world men suffer from habitual and societal genital mutilation at the hands of the other gender.\n\nCouple of things to unpack here. Generally FGM is performed by females. In those countries where FGM is practised, MGM is also practiced by equally incompetent people in equally unsanitary conditions leading to equally severe complications. So the countries I'd show you are all of them.\n\n>Please show me a society where a man is beaten to death by his community for being a rape victim. \n\nI can't do that, but in all those societies I can show you men being beaten to death for raping a woman who was actually just having extra-marital sex. She lied to protect herself and have him killed instead. Yaaaay. Again, not sexism, just a shithole.\n\nI don't have to show you shit, you haven't shown me anything.",
"Fuck off then?\n\nI've done pretty well today actually. You try the same, you cowardly little cunt :)",
"Ok but can you actually show me any rights men have which women don't in developed countries? Y'no, ones that aren't total shitholes. Can you give me real examples of what feminism can actually do to be of value? Not parroted rhetoric and a gross misunderstanding of human history.",
">Belief in or advocacy of **women's social, political, and economic rights**\n\nYeah sounds real fucking egalitarian.",
"No, it's not my experiences, it's men's experiences.\n\nWe can, but feminism does not aim to achieve gender equity.\n\nWe can, feminists don't.",
"You're the one who insulted me first, coward. Tuck your tail between your legs and fuck off.",
"None of those actually show that women suffer unequally in these countries though, do they? They just show that women suffer. Whoopdeedoo, I know that. Everyone does. I didn't dispute any of the things you've said about women's suffering. What do you think you've proven?\n\nI'd also suggest that cherry picking articles which support your position is not a very hard or convincing thing to do... Which is why I'm not wasting my time doing it, lmao.",
'You are not a source, you are an anecdote. One piece of data. The data suggests that they do.',
">We are less likely to be promoted because companies assume we will take more sick time to take care of children. \n\nMore maternity leave, I assume you mean. And, shouldn't you be? You work less. Should a woman who takes nine months off per year for three years get promoted over a woman who doesn't? Having children means you're out of work. That's unfortunate but what do you suggest we do? Promote people who are not the most qualified because they got knocked up? Let them ascend to a position they are unqualified for, watch them flounder and fail while the organisation struggles? Doesn't sound great for anyone involved. Life is unfair but that doesn't make it sexist.\n\n>We are judged if we say that we don't want to have kids. \n\nI'm sorry, what? So are men. People are judged for all sorts of things. This isn't an important issue at all.\n\n>We can't walk home alone at night without being afraid. \n\nNeither can men. We are much more likely to be assaulted than women are. Nobody should walk home alone at night, that is stupid.\n\n>I mean, do people ever yell at you from cars just because you are walking?\n\nYes. I've been catcalled, groped, sexually assaulted, raped and physically assaulted by strangers and those close to me. See this is the problem. Most women don't know or care about men's experiences because men don't fill their time complaining. We get shouted at, we get assaulted, we get hurt quite badly, we recover and we try to get on with our lives. Ask the men close to you if they have ever had someone beat them up, if they've ever had to go to hospital because a stranger beat the shit out of them. Bet you they all have, bet they've at least had black eyes or bleeding lips. Have you ever been hurt? I'm absolutely certain that you have. Is that because you're a woman? No, it's because people are assholes.\n\nAnd, I'm sorry, but a lot of these issues are quite insignificant compared to male genital mutilation, preferential treatment for women in all legal issues, preferential child custody for women, no reproductive rights for men. Sexual assault, sure, I empathise heavily with women on that one, it is awful... And, at the same time, I would say that male victims of sexual assault (who are far more numerous than you may think) have a much harder time seeking and getting help for it.\n\n>There are problems on both sides and you phrase it like women have somehow become super elevated in society. \n\nThey have. More women attend and graduate from higher education, a disproportionate amount of women are hired at all tiers of the workforce and younger women out-earn their male counterparts. The only thing stopping women from occupying more powerful positions is that they do not try to get them.\n\nYou may be told what to do, but you get to choose. You can choose what to do without consulting the father or notifying anyone. And many would argue that it's not your body you are making decisions about. Not me personally, I don't give a shit... But you must understand that is a complex issue, right?",
"I can read them, they do not suggest what you are claiming.\n\nI'll wait until you wish to continue.\n\nI do, off you fuck.",
">So then all catholics should account for the rape of priests\n\nLol. Yes, absolutely. They are members of an organisation that has permitted and facilitated the rape of children, are you serious? Of course they should be held accountable. Were they aware? Did they do anything to stop it? If not, why not? These are absolutely questions we should be asking and they should absolutely bear some responsibility for it.\n\n> All Christians should account for white nationalists and terrorists who attack people for their beliefs. \n\nYes. Their belief structure radicalises certain, vulnerable individuals, they are responsible.\n\n>We are all a part of groups that have members which twist our beliefs in different ways. \n\nThen hold those members accountable. Police, punish and eject them where necessary. You, as a member of feminism, are responsible for your group members. If you do not stop them, you will be held responsible for their actions. If you lack the power to stop them, leave, otherwise you are complicit.\n\n>Many of us condemn them but apparently that isn't enough for you.\n\nFucking right it's not. Is one priest condemning his colleagues for raping kids enough for you? Or should they maybe get rid of the priests who rape kids? HMM. I WONDER.",
"No, I'm talking about men's experiences. My experiences of feminism are unique and my own. Men's experiences of feminism are ill-informed social and legal policies that have diminished their rights and cultural identity, while advancing the position of women.\n\nGreat, good for you, you're blind. Next time you have a chat with them, ask them what they've actually done to help men, aside from posting shit on facebook and reddit.",
"> If you CAN read, but can not grasp the concept of another human being suffering for being the gender they are \n\nNo, I can grasp it. What I'm suggesting is that isn't what's happening. These are shithole countries where everyone suffers regardless of gender. And, for the record, not understanding something wouldn't make me a hypocrite, it would make me dumb.\n\n> I have never once argued with any of your claims. \n\nYou have though. Shall I quote you?\n\n> Please show me where in the world men suffer from habitual and societal genital mutilation at the hands of the other gender. Please show me a society where a man is beaten to death by his community for being a rape victim. Please show me the numbers and sources to back your claims. \n\n> Toxic masculinity is a big problem. Societal standards on men, in general, are just as harmful to men as they are women. \n\nToxic masculinity is not a problem. At least no more than toxic cuntslutfuckery. See we can both make up offensive, sexist terms which paint an entire gender as awful.\n\n> It doesn’t boil down to “shithole” countries \n\nIt does tho. Demonstrably.\n\n> It boils down to the fact that women ARE, factually, suffering \n\nSure, no more than men and, in many places, less. So why are we only encouraged to resolve women's issues? Not just that, resolve them no matter how petty they are, no matter how far away they are, while men in our own countries face egregious inequality. Yaaaaay feminism!\n\n> what you’re failing to realize is women aren’t the ones hurting men, typically speaking. \n\nAbsolute bullshit.\n\n> The same reasons you shit on feminists = same behavior you are actively engaging in right now. \n\nIt's a good attempt at an uno reverse but it's not actually true.\n\n>I’m not going to continue to argue with someone who cannot see reason. It truly is that simple. \n\nI'd love to see that. Seems you're actually a child who has to have the last word, even when they're wrong.",
'Ain\'t it? "I\'m done with you" - continues for two more hours, providing nothing but insults.',
'When I see any attempts to achieve equality I will change my mind.',
'I oscillate wildly.', 'Yeah fuck off.',
"No, I see what is actually there.\n\nYeah, that's bullshit. When you want to discuss this like someone with integrity would, you let me know.",
"Nah, I do. I'm just not willing to patiently sit there and let you lie through your teeth. When you want to talk, let me know, cunt.",
'Maybe because 90% of the responses are not from the people I actually asked. They\'re people trying to "educumacate" me about something I already understand better than they do. I asked two individuals for their perspective, not you for yours. Now fuck off until you have something useful to contribute.',
'I am. Next.', 'Try again.',
'If you ignore the part that makes it not egalitarian, it makes it egalitarian.\n\n\\- You',
'They really do represent the majority and those in powerful positions within the movement. Those who effect change are absolutely not interested in equality. If you call yourself a feminist you are complicit with their agenda. End of story.',
'K, bye.',
"No, this isn't a misogyny thing, I'm just speaking to a lot of very stupid people. I'd say that if you were male too.",
'K.',
">I'm not sure if you are aware, but there are many different sub-groups under the feminism umbrella. \n\nVery aware and they all share the same ideological foundation which is fundamentally oppositional and anti-male. This can be seen in the rhetoric, terminology, foci for change and data-collection methodology.\n\nNot interested in repeating the same discussion points again, I've done it several times now.\n\nBLM has strong anti-white elements and suffer from the same issue.\n\nYou are responsible for your movement and it has strong anti-male bias. Fix it, leave or accept the criticism.",
'Terry.',
">So do men on paper, in theory\n\nExcept they don't. Oops!\n\n>most feminists, myself included, think Amber deserves as much punishment as she would absolutely be getting if the genders were swapped.\n\nShame most feminists are doing fuck all about it then, isn't it?",
'Yes, plenty. Have a look at the sidebar.',
">I'd call myself a femminist. Femminism means equality between sexes.\n\nNo it doesn't. Clue is in the name.",
'I wish I could too but you keep irritating me.\n\nGot plenty. Fuck off.',
"Just behaving like feminists do. It's irritating isn't it? When you start actually investing some effort in helping men, I'll stop comparing suffering. Since, apparently, we have to fix all the most important issues first and all of those involve women making shit up.",
"Yeah you can claim that as much as you want. I could say a pile of shit is perfume but it isn't.",
"They have no reproductive rights and women receive preferential treatment in courts. The sidebar has more.\n\nThat's great. You ever feel like doing anything about it or just saying it's an important issue? Cos I don't actually see any feminists doing anything about it.",
"Yeah cos those are the things I'm referring to ;)",
"Nah, it's not. Eat shit.", 'Point missed.',
"So nothing? They've done nothing except claim men are responsible for men's suffering. Fuck off.\n\n> Also, in my feminists circles we hold each other accountable for toxic behaviour all the time. Like putting other women down for falling into traditional gender roles or hurting men or body shaming or whatever. \n\nSo you shame each other for not toeing the line? Sounds like brainwashing.\n\n> Also, yes society is ingrained with misogyny. \n\nNo it isn't.\n\n>Also if you're implying feminism is a marketing ploy\n\nI'm not implying it. I'm directly stating it. So take your deadass and fuck it right off.\n\n>Also gender norms are the reason men don't come forward to police when they're sexually assaulted. \n\nYeah and sometimes gender norms are helpful.\n\n>That's what feminists have been saying this whole time. If you spend you time watching Ben Shapiro owns feminist videos, you're not getting a real idea of what real feminism is.\n\nBen Shapiro is a cunt. I know what feminism is thanks.\n\n>Do your research, read bell hooks, read Kate bornstein, read roxane gray.\n\nDone it. Don't need literature recommendations from an ignorant, patronising turd, ta.\n\n>Get rid of this outdated idea of the feminazi and maybe we can talk again in a few years. Meanwhile, I'm done here bro.\n\nNope. Please stick to your words and actually fuck off.",
"Well if progress isn't equality then it isn't really progress is it?\n\nDon't really care.",
"I think you can do that yourself, without my help. Unless you're a simpleton.",
"Well if the actions of the organisation don't fit the definition, I will do exactly that.",
'Nah, just the people who are. Got nothing to add? Then fuck off.',
'You are indeed. Now go away.',
'Fine, disregard that one since it\'s convenient, I\'ll drop it. What about reproductive rights? Don\'t see you mentioning that one.\n\nNo, what have you actually done? You\'ve written some letters and done some volunteer work at somewhere which is both genders. What have you actually done to help men? I want some examples.\n\nI\'m doing a lot more than that, lol. I set up a group in my area for men experiencing mental health difficulties and social isolation to give them somewhere to meet new people and do interesting things. I used to work supporting homeless teens, primarily male, and helped them to learn how to look after themselves, their homes and their finances. I have run male-only therapeutic groups in my role as a psychologist and am one of very few male psychologists in my trust, which meant I helped set up a group for male psychologists following incidents of social exclusion and gender discrimination. I\'ve also done all the shit you\'ve "done" on top of that.',
'Cringe',
"Feminism. Yes, which is why I don't define myself as one.", 'K.',
"Even is sadder is that I already have! Nooooo! K, I'll use it to wank while we argue.",
'Yep. Quite a bit actually.',
'No, every organisation that has largely negative effects is bad. Like feminism, or Russia, or child traffickers.',
"I'd rather not, Tumblr is a pile of shit full of nobodies. And Amber Heard has lost no contracts and plans to litigate against Deep again. Again, when feminism does something instead of claiming to do things, I'll change my mind.",
"Feminism. It's not though. They're not fake feminists, they're the ones in charge of the movement. You are complicit in their actions. Take responsibility.",
"So what you're saying is you're a simpleton?",
'> Some MRAs are misogynistic, does that make the entire MRA movement bad? \n\nIf enough of them exist that it damages the movement, yes.\n\nTake responsibility, you coward.',
"Yep, and I have enough nobodies wasting my fucking time while I'm trying to polish my pork sword right now.\n\nThere is no evidence to the contrary. She has not been removed. The blogs, they do nothing! D:",
"It's not an ad-hominem. Refusing to take responsibility for your movement is cowardice, coward.",
"You wish! Slap some more shit on your face and we'll see if we can work with what you've got.",
"Never said that. There's plenty you can do, you just don't want to be alienated.",
'K, bye.', 'Fuck off then.', "It's called being a tosser.",
'Please do.',
"Yes, and it means there aren't plenty. It could mean none or it could mean any amount that isn't plenty, you insufferable tit.",
'Go for it, now stick to your words and fuck off.',
">The first things that come to mind are abortion\n\nWhy do you think access to abortion is a right you deserve? Many would dispute that. I wouldn't, personally, but that is a very complex issue and it's not about being a woman, it's about religious beliefs. Secondly there would be absolutely no equality in granting women the right to abortion without similar reproductive rights being granted to men. This is actually anti-equality without comparable male rights being granted also.\n\n> access to birth control (esp. surgical methods) \n\nNot an inequality issue. Pay for it yourself like men have to.\n\n>pay equality (though granted that’s only solvable through parental leave and guarantee of return to positions after child birth because on paper women make as much as men).\n\nOk, so you already have pay equality and the vast majority of places have government mandated maternity leave which far exceeds paternity leave. Any further progress in that area would only widen the pre-existing inequality which favours women. Pay equality is an issue that has long been solved and, again, has exceeded its mandate, now favouring women in the workplace.\n\n>At this point most of the issues that women are looking for legal protections on are issues that are uniquely female.\n\nWhat a shocker!\n\nSo far you've actually given me no examples of where women do not have equality with men. Could you answer the question I asked, please?\n\n>Feminism has always been about creating more equity,\n\nNo, it was a female advocacy group.\n\n>at this point we’ve achieved most of the larger legislative issues \n\nSo why don't you turn some of that focus towards male issues where there are gaping legislative inequalities?\n\n>Only recently (what are we on now “6th wave feminism”?) has this man-hating started to emerge and that was never really the point.\n\nJust. Lol. That is total bullshit. Man-hating has been around since the inception of feminism.",
"Why? You said you were leaving, so leave. You aren't getting the last word in, you petty coward."],
dtype=object)
df_users[df_users.user_name == 'pacmatt27']
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 12865 | pacmatt27 | True | False | False | False | 36552.0 | 1632.0 | 2014-02-08 15:05:44 | others | others |
sum(sum([df_pacmatt27[df_pacmatt27.text.str.contains('fuck')].created_at.dt.date == datetime.date(2020, 11, 7)]).values)
12
suspected_dict['pacmatt27'] = 'Created at:2014-02-08 , used the word f*ck in 12 negative comments in NOV 7 2020'
suspected_dict
{'cracksniffer666': 'Created at:uknown date, used the word f*ck in 13 negative comments in FEB 10 2020',
'pacmatt27': 'Created at:2014-02-08 , used the word f*ck in 12 negative comments in NOV 7 2020'}
df_pacmatt27_contributions = df_pacmatt27.groupby(df_pacmatt27.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_pacmatt27_contributions,
x='created_at',
y='n_contributions', title='The number of "pacmatt27" contributions in 2020')
fig.update_traces(marker_color='red', marker_line_width=2, opacity=1, textposition='auto')
fig.show()
94 contributions in 7 nov 2020
df.text.value_counts().head(100)
[deleted] 3800
[removed] 1534
Amber Heard 958
Make sure to follow our community guidelines.\n\n**[Get user flair](https://redd.it/e0a4mn) and check out our [Instagram page](https://www.instagram.com/celebtag) for more celebrity content!**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/Celebhub) if you have any questions or concerns.* 143
Rule 9 overused. No Johny Depp or Amber Heard memes at this time\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/memes) if you have any questions or concerns.* 105
...
Fuck this bitch 14
Margot 14
Make sure to follow our community guidelines.\n\n**[Get user flair](https://redd.it/e0a4mn) and check out our Instagram page for more celebrity content!**\n\n**https://www.instagram.com/celebtag**\n\n\n*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/Celebhub) if you have any questions or concerns.* 14
I did mine 14
I agree 13
Name: text, Length: 100, dtype: int64
Notes:
df[df.text.str.lower().str.contains("fuck amber heard") ]
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130 | t3_ems2vg | /r/JerkOffToCelebs/comments/ems2vg/how_roughly... | How roughly would you throatfuck Amber Heard? | NaN | r/JerkOffToCelebs | flightfight1 | 2020-01-10 15:01:14 | Negative | Neutral | 68.0 | NaN | submission | 7 | how_roughly_would_you_throatfuck_amber_heard | 7 | [] | 0 |
| 137 | t3_emyakx | /r/celebJObuds/comments/emyakx/how_roughly_wou... | How roughly would you facefuck Amber Heard? | NaN | r/celebJObuds | flightfight1 | 2020-01-10 22:25:04 | Negative | Neutral | 16.0 | NaN | submission | 7 | how_roughly_would_you_facefuck_amber_heard | 7 | [] | 0 |
| 1725 | t1_fg7u7bi | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | I was in a thread a few weeks ago discussing t... | t3_ex9ge9 | r/iamatotalpieceofshit | -banned- | 2020-02-01 23:59:25 | Neutral | Neutral | 129.0 | submission | comment | 47 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 1801 | t1_fg7xv4g | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | I have downvoted every Amber Heard post since ... | t3_ex9ge9 | r/iamatotalpieceofshit | Ballistic_86 | 2020-02-02 00:44:27 | Negative | Neutral | 59.0 | submission | comment | 108 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 1927 | t1_fg829td | /r/iamatotalpieceofshit/comments/ex9ge9/amber_... | Alright Reddit, time to post daily PSA's and c... | t1_fg7i39x | r/iamatotalpieceofshit | -banned- | 2020-02-02 01:40:01 | Negative | Neutral | 56.0 | comment | comment | 80 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 128124 | t3_kn6guq | /r/u_ho3lita/comments/kn6guq/please_sign_these... | Please sign these petitions, fuck Amber Heard | NaN | u/ho3lita | ho3lita | 2020-12-30 17:26:15 | Negative | Neutral | 2.0 | NaN | submission | 7 | u_ho3lita | 2 | [] | 0 |
| 128125 | t3_kn6o3y | /r/memes/comments/kn6o3y/fuck_amber_heard/ | Fuck Amber Heard | NaN | r/memes | -banned- | 2020-12-30 17:36:40 | Negative | Negative | 1.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
| 128177 | t1_ghjg1i1 | /r/CelebBattles/comments/kn05yn/dc_babes_gal_g... | Fuck amber heard me and all the homies hate am... | t3_kn05yn | r/CelebBattles | ConnorD0509 | 2020-12-30 21:37:48 | Negative | Negative | 10.0 | submission | comment | 11 | dc_babes_gal_gadot_vs_amber_heard_vs_cara | 9 | [] | 0 |
| 128212 | t3_kndzg7 | /r/memes/comments/kndzg7/fuck_amber_heard/ | Fuck Amber Heard | NaN | r/memes | -banned- | 2020-12-30 23:50:45 | Negative | Negative | 1.0 | NaN | submission | 3 | fuck_amber_heard | 3 | [] | 0 |
| 128347 | t1_ghm996j | /r/asklatinamerica/comments/kno5sw/how_would_y... | It's not great, but I've heard worse. 6/10. Fu... | t3_kno5sw | r/asklatinamerica | Ponchorello7 | 2020-12-31 16:33:32 | Negative | Negative | 7.0 | submission | comment | 17 | how_would_you_rate_amber_heards_spanish_skills | 8 | [] | 0 |
413 rows × 17 columns
df_fu = df[df.text.str.lower().str.contains("fuck amber heard")]
print(df_fu.shape)
with pd.option_context('display.max_colwidth', None):
display(df_fu.head())
(413, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130 | t3_ems2vg | /r/JerkOffToCelebs/comments/ems2vg/how_roughly_would_you_throatfuck_amber_heard/ | How roughly would you throatfuck Amber Heard? | NaN | r/JerkOffToCelebs | flightfight1 | 2020-01-10 15:01:14 | Negative | Neutral | 68.0 | NaN | submission | 7 | how_roughly_would_you_throatfuck_amber_heard | 7 | [] | 0 |
| 137 | t3_emyakx | /r/celebJObuds/comments/emyakx/how_roughly_would_you_facefuck_amber_heard/ | How roughly would you facefuck Amber Heard? | NaN | r/celebJObuds | flightfight1 | 2020-01-10 22:25:04 | Negative | Neutral | 16.0 | NaN | submission | 7 | how_roughly_would_you_facefuck_amber_heard | 7 | [] | 0 |
| 1725 | t1_fg7u7bi | /r/iamatotalpieceofshit/comments/ex9ge9/amber_heard_admits_abusing_johnny_depp_even/fg7u7bi/ | I was in a thread a few weeks ago discussing this very thing and this self-proclaimed "lawyer" in the comments was saying Depp was as equal a piece of shit as Heard just because he spends his money unwisely and has financial issues lmao \n\n\nFuck Amber Heard | t3_ex9ge9 | r/iamatotalpieceofshit | -banned- | 2020-02-01 23:59:25 | Neutral | Neutral | 129.0 | submission | comment | 47 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 1801 | t1_fg7xv4g | /r/iamatotalpieceofshit/comments/ex9ge9/amber_heard_admits_abusing_johnny_depp_even/fg7xv4g/ | I have downvoted every Amber Heard post since I joined Reddit. \n\nI first heard about this situation on the JRE. Comedian Doug Stanhope made an unlikely friendship with Johnny Depp several year ago. When Amber’s accusations of abuse came out, Doug spoke on that to Joe. Neither had any vested interest in making Johnny or Amber look good. \n\nIn a “he said” “she said” situation, third party observance is usually my go to for what is actually happening. Also the fact that Johnny was never charged with a crime.\n\nFuck Amber Heard, I hope her acting career is truly over. She is an abusive person and a liar. | t3_ex9ge9 | r/iamatotalpieceofshit | Ballistic_86 | 2020-02-02 00:44:27 | Negative | Neutral | 59.0 | submission | comment | 108 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
| 1927 | t1_fg829td | /r/iamatotalpieceofshit/comments/ex9ge9/amber_heard_admits_abusing_johnny_depp_even/fg829td/ | Alright Reddit, time to post daily PSA's and create bots to obsessively remind people about this abuser's crime whenever they're mentioned. \n \nYou know, same energy that dude, Chris Brown, gets. \nMaybe post a few random "fuck amber heard" and "it's disgusting how she's allowed to work" posts? "Lose respect" for everyone that has worked with her? Complain about streaming services showing her movies? \n \nHopefully r/trollxchromosomes and twitter are gonna be just as militant as when people started doubting her story... | t1_fg7i39x | r/iamatotalpieceofshit | -banned- | 2020-02-02 01:40:01 | Negative | Neutral | 56.0 | comment | comment | 80 | amber_heard_admits_abusing_johnny_depp_even | 7 | [] | 0 |
df_fu.subreddit.value_counts()
r/memes 77
r/awfuleverything 32
r/videos 22
r/iamatotalpieceofshit 22
r/dankmemes 20
..
r/TrueFMK 1
r/changemyview 1
r/fakehistoryporn 1
r/TheRightCantMeme 1
r/FuckYouAmberHeard 1
Name: subreddit, Length: 92, dtype: int64
df_fu.author.value_counts()
-banned- 82
lobofett12 7
SlimandNone 3
flightfight1 3
Sociopathic-Panda 3
..
Clobbersauze 1
iamboedefeld 1
violettigerlilly1999 1
Rocatex 1
Good-Bumblebee3642 1
Name: author, Length: 310, dtype: int64
df_fu.submission_comment.value_counts()
comment 274 submission 139 Name: submission_comment, dtype: int64
fu_list = df_fu.author.value_counts().index.to_list()
fu_list = fu_list[1:]
df_users[df_users['user_name'].isin(fu_list)]
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 516 | Shugyosha | True | True | False | False | 19270.0 | 781.0 | 2009-01-13 07:27:16 | others | others |
| 2662 | FrayAdjacent | True | False | False | False | 50110.0 | 824.0 | 2011-06-04 01:57:00 | others | others |
| 4546 | Z0MGbies | True | False | False | False | 126259.0 | 15435.0 | 2012-01-17 00:57:17 | others | others |
| 4803 | BarryMacochner | True | False | False | False | 95737.0 | 1621.0 | 2012-02-07 00:31:03 | others | others |
| 5099 | _______walrus | True | False | False | False | 39283.0 | 4566.0 | 2012-03-06 07:22:58 | others | others |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 69605 | pastel_knives | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69866 | gippalx | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 70064 | JenxxJay | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 70068 | RectumGoblin | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 70280 | Yolo1235 | True | True | True | True | NaN | NaN | NaT | banned | banned |
309 rows × 10 columns
df_fu_contributions = df_fu.groupby(df_fu.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_fu_contributions,
x='created_at',
y='n_contributions', title='The number of "F*ck Amber Heard" contributions in 2021')
# , marker_line_color='#5296dd'
fig.show()
text = "amber heard bad"
df_bad = df[df.text.str.lower().str.contains(text)]
print(df_bad.shape)
with pd.option_context('display.max_colwidth', None):
display(df_bad.head())
(103, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26942 | t1_fgow1av | /r/askteenboys/comments/ezie45/what_do_think_about_the_johnny_depp_and_amber/fgow1av/ | Johnny depp good amber heard bad | t3_ezie45 | r/askteenboys | MrMeme2K23 | 2020-02-06 11:39:21 | Neutral | Neutral | 2.0 | submission | comment | 6 | what_do_think_about_the_johnny_depp_and_amber | 9 | [] | 0 |
| 30314 | t3_f087pw | /r/circlejerk/comments/f087pw/amber_heard_bad_men_together_strong/ | Amber Heard BAD. Men together strong | NaN | r/circlejerk | -banned- | 2020-02-07 09:32:39 | Negative | Neutral | 0.0 | NaN | submission | 6 | amber_heard_bad_men_together_strong | 6 | [] | 0 |
| 50145 | t3_fiiyr2 | /r/dankmemes/comments/fiiyr2/amber_heard_bad/ | Amber Heard bad | NaN | r/dankmemes | lievenazerty | 2020-03-14 14:13:40 | Negative | Negative | 28.0 | NaN | submission | 3 | amber_heard_bad | 3 | [] | 0 |
| 57690 | t3_fxgvwd | /r/FreeKarma4You/comments/fxgvwd/upvote_if_johnny_depp_good_amber_heard_bad_ill/ | Upvote if johnny depp good amber heard bad. Ill upvote you back. | NaN | r/FreeKarma4You | _M0b | 2020-04-08 23:00:19 | Negative | Neutral | 35.0 | NaN | submission | 12 | upvote_if_johnny_depp_good_amber_heard_bad_ill | 9 | [] | 0 |
| 57742 | t3_fxhv2t | /r/circlejerk/comments/fxhv2t/amber_heard_bad_johnny_depp_good/ | Amber Heard bad. Johnny Depp good. | NaN | r/circlejerk | pomanE | 2020-04-09 00:00:04 | Neutral | Neutral | 5.0 | NaN | submission | 6 | amber_heard_bad_johnny_depp_good | 6 | [] | 0 |
df_bad.author.value_counts()
-banned- 35
lobofett12 2
Jozilla12 2
Apple20674 2
Shaved_Bears 2
..
madcodez 1
papryustheskeleton 1
InformalRemove7 1
IslewardMan 1
chuck_is_dead_vay_aq 1
Name: author, Length: 63, dtype: int64
bad_list = df_bad.author.value_counts().index.to_list()
bad_list = bad_list[1:]
df_bad.subreddit.value_counts()
r/memes 51 r/dankmemes 15 r/redditmoment 7 r/circlejerk 5 r/teenagers 2 r/CaptainSparrowmemes 2 r/Amber_Heard 2 r/MensRights 2 r/unfunnyredditposts 1 r/FreeKarma4You 1 r/wholesomememes 1 r/ComedyHitmen 1 r/redditshutthefuckup 1 r/MetaRunner 1 r/PewdiepieSubmissions 1 r/moviescirclejerk 1 u/AndrewTheMandrew13 1 r/MemeTemplatesOfficial 1 r/me_irl 1 r/AntiHateCommunities 1 r/agedlikemilk 1 r/FragileMaleRedditor 1 r/meme 1 r/copypasta 1 r/askteenboys 1 Name: subreddit, dtype: int64
df_bad.submission_comment.value_counts()
submission 91 comment 12 Name: submission_comment, dtype: int64
df_users[df_users['user_name'].isin(bad_list)]
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 3099 | pomanE | False | False | False | False | 5289.0 | 3678.0 | 2011-08-07 14:21:09 | unverified | others |
| 12654 | Doggcow | True | False | False | False | 37048.0 | 66826.0 | 2014-01-21 08:08:27 | others | others |
| 13618 | Wackylew | True | True | False | False | 98211.0 | 45754.0 | 2014-04-18 17:35:37 | others | others |
| 14066 | lievenazerty | True | False | False | False | 5373.0 | 5467.0 | 2014-05-31 23:12:57 | others | others |
| 19832 | lobofett12 | True | True | False | False | 14458.0 | 428266.0 | 2015-09-23 18:13:04 | others | others |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 68979 | RatMan713 | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69623 | izym17 | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69897 | Uwuwuwuuwuwuowo | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69900 | j0eylonglegs | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69913 | IslewardMan | True | True | True | True | NaN | NaN | NaT | banned | banned |
62 rows × 10 columns
df_bad_contributions = df_bad.groupby(df_bad.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_bad_contributions,
x='created_at',
y='n_contributions', title='The number of "Amber Heard Bad" contributions in 2021')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.5, opacity=1, textposition='auto')
fig.show()
text = "amber turd"
df_turd = df[df.text.str.lower().str.contains(text)]
print(df_turd.shape)
with pd.option_context('display.max_colwidth', None):
display(df_turd.head())
(429, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6786 | t1_fgd481y | /r/MensRights/comments/exfjhc/in_light_of_the_recent_audio_tape_release_i_think/fgd481y/ | It's now at 75 thousand. That's a more than fifty percent increase in just a day or so, after being stuck at less than 50 thousand for almost a year. People are *really* pissed off at Amber Turd. Er...i mean Amber Heard... | t3_exfjhc | r/MensRights | ThePigmanAgain | 2020-02-02 21:26:31 | Positive | Neutral | 2.0 | submission | comment | 42 | in_light_of_the_recent_audio_tape_release_i_think | 10 | [] | 0 |
| 17041 | t1_fgj9bjl | /r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgj9bjl/ | Amber Turd - Don’t believe a word. | t3_eyp2d3 | r/videos | StrangelyBeige | 2020-02-04 18:05:43 | Neutral | Neutral | 1.0 | submission | comment | 7 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 19533 | t1_fgjvbt0 | /r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgjvbt0/ | She has the aduacity to be a campaginer for domestic violence awareness when shes a part of the problem. Fuck you Amber Turd | t3_eyp2d3 | r/videos | TeehSandMan | 2020-02-04 21:35:01 | Negative | Negative | 3.0 | submission | comment | 23 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 21133 | t1_fgkiayw | /r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgkiayw/ | Aka Amber Turd | t3_eyp2d3 | r/videos | General-Explanation | 2020-02-05 01:30:13 | Neutral | Neutral | 1.0 | submission | comment | 3 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 22834 | t1_fgma3wu | /r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/fgma3wu/ | Probably not because they’re still delusional and think Amber Turd is the innocent widdle angel that would never hurt anyone. | t1_fgirw8w | r/videos | -banned- | 2020-02-05 16:38:59 | Positive | Positive | 1.0 | comment | comment | 20 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
df_turd.submission_comment.value_counts()
comment 418 submission 11 Name: submission_comment, dtype: int64
df_turd.subreddit.value_counts()
r/memes 44
r/MensRights 29
r/celebnsfw 22
r/entertainment 20
r/pussypassdenied 19
..
r/MurderedByWords 1
r/MMA 1
r/DCEUleaks 1
r/Vent 1
r/TooAfraidToAsk 1
Name: subreddit, Length: 97, dtype: int64
df_turd.author.value_counts()
-banned- 38
SquidAndCheese 12
Nayr747 5
Jaya_shanka 4
ginozilla1985 4
..
buggerthis81 1
G_A_M_E_R_R 1
SBSmyth_68 1
DumasThePharaoh 1
Kleon_da_cat 1
Name: author, Length: 338, dtype: int64
turd_list = df_turd.author.value_counts().index.to_list()
turd_list = turd_list[1:]
df_users[df_users['user_name'].isin(turd_list)]
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | lordatlas | True | False | False | False | 37236.0 | 44676.0 | 2006-02-16 02:15:23 | others | others |
| 87 | Sabremesh | True | True | False | False | 64497.0 | 172797.0 | 2007-03-24 15:11:41 | others | others |
| 95 | malarie | True | False | False | False | 7660.0 | 10507.0 | 2007-04-18 03:39:23 | others | others |
| 127 | Marutar | True | True | False | False | 50869.0 | 783.0 | 2007-06-16 19:38:58 | others | others |
| 411 | jameson71 | True | True | False | False | 18558.0 | 12.0 | 2008-08-21 04:05:27 | others | others |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 69651 | Galvatron1117 | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69801 | bloodthorn1990 | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69880 | PlatinumPepe | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 69889 | -Cyber_Renaissance | True | True | True | True | NaN | NaN | NaT | banned | banned |
| 70137 | Dondo1978 | True | True | True | True | NaN | NaN | NaT | banned | banned |
337 rows × 10 columns
df_turd_contributions = df_turd.groupby(df_turd.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_turd_contributions,
x='created_at',
y='n_contributions', title='The number of "Amber Turd" contributions in 2020')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.5, opacity=1, textposition='auto')
# ,
fig.show()
7 November was a peack in negative contributions
Check the number of text words
Of course few words are easier for bots to create
df['text_words'].value_counts().head(10);
px.histogram(df['text_words'].to_frame(), x="text_words",title='number of words in each contribution',
nbins=200).update_traces(marker_color='#5296dd')
df['text_words'].to_frame().value_counts()
text_words
1 10206
5 4789
6 4723
4 4461
7 4458
...
364 1
550 1
551 1
552 1
1708 1
Length: 604, dtype: int64
The number of parent comments on submissions¶
px.bar(data_frame=df['top_level'].value_counts().to_frame().reset_index(),
x="index", y="top_level").update_layout(title='Comment or Submission (Top Level of Contrbution "Parent")',
xaxis_title='contribution top level (parent) category',
yaxis_title='number of contributions').update_traces(marker_color='#5296dd')
This means that we have about 83K parent comments on submissions (not replies).
Investigating the Submission Text
(Submissions with the most comments and replies)
We can get the number of different submissions by looking only at the submissions dataframe
Also we can look at submission_text with the most interactions (repeated submission_text)
df['submission_text'].value_counts().head(10)
This could be either submissions with more comments and replies, or different submissions with the same text, we cannot know for sure.
df_audio = df.query(" submission_text == 'audio_of_amber_heard_admitting_she_was_the_one' & \
submission_comment == 'submission' ")
print(df_audio.shape)
with pd.option_context('display.max_colwidth', None):
display(df_audio.head())
(10, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11610 | t3_eyp2d3 | /r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/ | Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp. | NaN | r/videos | KindlyOlPornographer | 2020-02-04 12:04:19 | Neutral | Negative | 98525.0 | NaN | submission | 15 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 12604 | t3_eyqutf | /r/MensRights/comments/eyqutf/audio_of_amber_heard_admitting_she_was_the_one/ | Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp. | NaN | r/MensRights | xool420 | 2020-02-04 14:31:32 | Neutral | Negative | 27.0 | NaN | submission | 15 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 12666 | t3_eyqw0c | /r/TwoXChromosomes/comments/eyqw0c/audio_of_amber_heard_admitting_she_was_the_one/ | Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp. | NaN | r/TwoXChromosomes | -banned- | 2020-02-04 14:34:07 | Neutral | Negative | 2.0 | NaN | submission | 15 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 13613 | t3_eyrh1b | /r/Feminism/comments/eyrh1b/audio_of_amber_heard_admitting_she_was_the_one/ | Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp | NaN | r/Feminism | -banned- | 2020-02-04 15:15:39 | Neutral | Negative | 1.0 | NaN | submission | 15 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 13979 | t3_eyror4 | /r/blankies/comments/eyror4/audio_of_amber_heard_admitting_she_was_the_one/ | Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp. | NaN | r/blankies | redditchao999 | 2020-02-04 15:30:07 | Neutral | Negative | 6.0 | NaN | submission | 15 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
df_audio.submission_comment
11610 submission 12604 submission 12666 submission 13613 submission 13979 submission 16192 submission 20937 submission 21438 submission 21881 submission 50005 submission Name: submission_comment, dtype: object
df_audio.subreddit
11610 r/videos 12604 r/MensRights 12666 r/TwoXChromosomes 13613 r/Feminism 13979 r/blankies 16192 r/BillBurr 20937 r/movies 21438 r/Feminism 21881 r/MensRights 50005 r/videos Name: subreddit, dtype: object
li = list(df_audio.author.unique())
li.remove('-banned-')
df_users[df_users.user_name.isin(li)]
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 3767 | redditchao999 | True | True | False | False | 32903.0 | 7543.0 | 2011-10-30 02:01:08 | others | others |
| 5918 | snoogins355 | True | False | False | False | 238857.0 | 19722.0 | 2012-05-27 13:57:43 | others | others |
| 18703 | xool420 | True | False | False | False | 89122.0 | 94801.0 | 2015-06-25 13:49:35 | others | others |
| 50576 | KindlyOlPornographer | True | False | False | False | 157950.0 | 92848.0 | 2019-07-27 01:15:02 | others | 2019 |
| 52089 | yespineapplebacon | True | False | False | False | 1821.0 | 21692.0 | 2019-09-10 20:07:38 | others | 2019 |
| 57013 | poop4456 | False | False | False | False | 130.0 | 138.0 | 2020-02-04 17:44:20 | unverified | 2020 |
| 67607 | waifulvr94 | True | True | True | True | NaN | NaN | NaT | banned | banned |
df_audio_comments = df.query(" submission_text == 'audio_of_amber_heard_admitting_she_was_the_one' ")
print(df_audio_comments.shape)
df_audio_comments.head(1)
(9562, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11610 | t3_eyp2d3 | /r/videos/comments/eyp2d3/audio_of_amber_heard... | Audio of Amber Heard admitting she was the one... | NaN | r/videos | KindlyOlPornographer | 2020-02-04 12:04:19 | Neutral | Negative | 98525.0 | NaN | submission | 15 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
df_audio_contributions = df_audio_comments.groupby(df_audio_comments.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_audio_contributions.head(7),
x='created_at',
y='n_contributions', title='The number of contributions/date on these submissions')
fig.update_layout(
xaxis = dict(
title='Contribution Date',
tickmode = 'array',
tickvals = df_audio_contributions.head(7).created_at,
)
)
clrs = ['red' if (y > 200) else '#5296dd' for y in df_audio_contributions.n_contributions]
fig.update_traces(marker_color=clrs, marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
df_audio_authors = df_audio_comments.groupby(df_audio_comments.author).size().reset_index(name='n_contributions')
fig = px.bar(df_audio_authors,
x='author',
y='n_contributions', title='The number of contributions per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.5,opacity=1, textposition='auto')
# , marker_line_color='#5296dd', marker_line_width=2
fig.update_yaxes(range = [0,25])
fig.show()
df_audio_authors.sort_values('n_contributions', ascending=False)
| author | n_contributions | |
|---|---|---|
| 8 | -banned- | 1218 |
| 4582 | waitingtodiesoon | 46 |
| 461 | ClementineCarson | 45 |
| 3348 | gorgossia | 34 |
| 1264 | KindlyOlPornographer | 30 |
| ... | ... | ... |
| 1854 | QwertyBoi321 | 1 |
| 1855 | R-Van | 1 |
| 1856 | R4K1B- | 1 |
| 1857 | R4nd0m235689 | 1 |
| 2354 | The_Billy_Dee | 1 |
4708 rows × 2 columns
df_audio_comments[(df_audio_comments.author == 'waitingtodiesoon') |
(df_audio_comments.author == 'ClementineCarson')].
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12922 | t1_fgioybp | /r/videos/comments/eyp2d3/audio_of_amber_heard... | Makes me almost disappointed I saw Aquaman 9x.... | t1_fgiksxi | r/videos | waitingtodiesoon | 2020-02-04 14:46:05 | Negative | Neutral | 883.0 | comment | comment | 47 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 13110 | t1_fgippjw | /r/videos/comments/eyp2d3/audio_of_amber_heard... | I am hoping johnny depp is vindicated from thi... | t1_fgikd5z | r/videos | waitingtodiesoon | 2020-02-04 14:54:39 | Positive | Positive | 9.0 | comment | comment | 57 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 13663 | t1_fgirs4p | /r/videos/comments/eyp2d3/audio_of_amber_heard... | Like that other person who took part in a grou... | t1_fgiic5w | r/videos | ClementineCarson | 2020-02-04 15:17:44 | Negative | Neutral | 6.0 | comment | comment | 23 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 13710 | t1_fgirx3l | /r/videos/comments/eyp2d3/audio_of_amber_heard... | I find it funny out of all the states he parto... | t1_fgimev9 | r/videos | ClementineCarson | 2020-02-04 15:19:14 | Positive | Positive | 0.0 | comment | comment | 22 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 13714 | t1_fgirxp5 | /r/videos/comments/eyp2d3/audio_of_amber_heard... | I loved that movie. Jason Momoa, Willim Dafoe,... | t1_fgiplu8 | r/videos | waitingtodiesoon | 2020-02-04 15:19:25 | Positive | Positive | -3.0 | comment | comment | 114 | audio_of_amber_heard_admitting_she_was_the_one | 9 | ['https://www.carnival.com'] | 1 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 25303 | t1_fgnmh6o | /r/videos/comments/eyp2d3/audio_of_amber_heard... | If a list existed during Fury Road release I w... | t1_fgj250l | r/videos | waitingtodiesoon | 2020-02-06 00:14:19 | Positive | Negative | 1.0 | comment | comment | 35 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 25374 | t1_fgnncte | /r/videos/comments/eyp2d3/audio_of_amber_heard... | I love movies and I believe one of the best wa... | t1_fgjk8i8 | r/videos | waitingtodiesoon | 2020-02-06 00:23:57 | Positive | Positive | 1.0 | comment | comment | 141 | audio_of_amber_heard_admitting_she_was_the_one | 9 | ['http://www.imaxprivatetheatre.com'] | 1 |
| 25385 | t1_fgnnk9a | /r/videos/comments/eyp2d3/audio_of_amber_heard... | 8x. 1 more after I bought the 4k blu-ray. | t1_fgiq62n | r/videos | waitingtodiesoon | 2020-02-06 00:26:13 | Positive | Neutral | 2.0 | comment | comment | 9 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 25396 | t1_fgnno5o | /r/videos/comments/eyp2d3/audio_of_amber_heard... | Have an open mind and immerse yourself in the ... | t1_fgjbwpq | r/videos | waitingtodiesoon | 2020-02-06 00:27:26 | Neutral | Positive | 1.0 | comment | comment | 12 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
| 25416 | t1_fgno20x | /r/videos/comments/eyp2d3/audio_of_amber_heard... | The only film I know of where he showed up lat... | t1_fgiw9q9 | r/videos | waitingtodiesoon | 2020-02-06 00:31:39 | Negative | Negative | 1.0 | comment | comment | 78 | audio_of_amber_heard_admitting_she_was_the_one | 9 | [] | 0 |
91 rows × 17 columns
df_audio2 = df.query(" submission_text == 'johnny_depp_amber_heard_new_unsensored_audio' & \
submission_comment == 'submission' ")
print(df_audio2.shape)
with pd.option_context('display.max_colwidth', None):
display(df_audio2.head())
(6, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33547 | t3_f0q0ao | /r/videos/comments/f0q0ao/johnny_depp_amber_heard_new_unsensored_audio/ | Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof. | NaN | r/videos | Ethernetbabe | 2020-02-08 10:39:34 | Positive | Positive | 81052.0 | NaN | submission | 33 | johnny_depp_amber_heard_new_unsensored_audio | 7 | [] | 0 |
| 35662 | t3_f0tg5b | /r/trashy/comments/f0tg5b/johnny_depp_amber_heard_new_unsensored_audio/ | Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof. | NaN | r/trashy | EpixBubble | 2020-02-08 16:01:14 | Positive | Positive | 1.0 | NaN | submission | 33 | johnny_depp_amber_heard_new_unsensored_audio | 7 | [] | 0 |
| 38274 | t3_f0xgin | /r/popularpost/comments/f0xgin/johnny_depp_amber_heard_new_unsensored_audio/ | Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof. | NaN | r/popularpost | Alexexec | 2020-02-08 20:46:40 | Positive | Positive | 2.0 | NaN | submission | 33 | johnny_depp_amber_heard_new_unsensored_audio | 7 | [] | 0 |
| 38952 | t3_f0yz17 | /r/JusticeForJohnnyDepp/comments/f0yz17/johnny_depp_amber_heard_new_unsensored_audio/ | Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him. | NaN | r/JusticeForJohnnyDepp | HWGA_Gallifrey | 2020-02-08 22:34:28 | Positive | Neutral | 21.0 | NaN | submission | 16 | johnny_depp_amber_heard_new_unsensored_audio | 7 | [] | 0 |
| 50020 | t3_fhipze | /r/videos/comments/fhipze/johnny_depp_amber_heard_new_unsensored_audio/ | Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof. | NaN | r/videos | waifulvr94 | 2020-03-12 16:09:31 | Positive | Positive | 1.0 | NaN | submission | 33 | johnny_depp_amber_heard_new_unsensored_audio | 7 | [] | 0 |
6 Different Submissions
all posts have the same video:
https://www.youtube.com/watch?time_continue=2&v=Cg9SvQSMnoE&feature=emb_title
those submissions were archived
li = list(df_audio2.author.unique())
df_users[df_users.user_name.isin(li)]
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 13464 | Ethernetbabe | True | True | False | False | 24276.0 | 95091.0 | 2014-04-05 13:36:07 | others | others |
| 39549 | Alexexec | True | True | False | False | 43154.0 | 5363.0 | 2018-08-27 07:43:54 | others | 2018 |
| 49304 | HWGA_Gallifrey | False | False | False | False | 74419.0 | 928.0 | 2019-06-17 00:09:27 | unverified | 2019 |
| 49870 | EpixBubble | True | True | False | False | 1196.0 | 13592.0 | 2019-07-05 12:02:43 | others | 2019 |
| 67607 | waifulvr94 | True | True | True | True | NaN | NaN | NaT | banned | banned |
df_audio2_comments = df.query(" submission_text == 'johnny_depp_amber_heard_new_unsensored_audio' ")
print(df_audio2_comments.shape)
df_audio2_comments.head(1)
(6218, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33547 | t3_f0q0ao | /r/videos/comments/f0q0ao/johnny_depp_amber_he... | Johnny Depp & Amber Heard: NEW Unsensored Audi... | NaN | r/videos | Ethernetbabe | 2020-02-08 10:39:34 | Positive | Positive | 81052.0 | NaN | submission | 33 | johnny_depp_amber_heard_new_unsensored_audio | 7 | [] | 0 |
df_audio2_contributions = df_audio2_comments.groupby(df_audio2_comments.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_audio2_contributions.head(4),
x='created_at',
y='n_contributions', title='The number of contributions/date on these submissions')
fig.update_layout(
xaxis = dict(
title='Contribution Date',
tickmode = 'array',
tickvals = df_audio2_contributions.head(4).created_at,
)
)
clrs = ['red' if (y > 200) else '#5296dd' for y in df_audio2_contributions.n_contributions]
fig.update_traces(marker_color=clrs, marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
df_audio2_authors = df_audio2_comments.groupby(df_audio2_comments.author).size().reset_index(name='n_contributions')
fig = px.bar(df_audio2_authors,
x='author',
y='n_contributions', title='The number of contributions per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.3
, textposition='auto')
# ,
fig.update_yaxes(range = [0,25])
fig.show()
df_audio2_authors.sort_values('n_contributions', ascending=False)
| author | n_contributions | |
|---|---|---|
| 5 | -banned- | 823 |
| 2009 | controlandr3sistanc3 | 80 |
| 1212 | PraiseSatsuki | 64 |
| 2063 | demonicneon | 51 |
| 768 | JagTror | 36 |
| ... | ... | ... |
| 1177 | Pengroves | 1 |
| 1178 | Penla | 1 |
| 1181 | PerfectZeong | 1 |
| 1182 | Petdogdavid1 | 1 |
| 3099 | zyzzogeton | 1 |
3100 rows × 2 columns
df_audio2_comments[df_audio2_comments.author == 'controlandr3sistanc3'].text.value_counts()
Care to quote a statement of mine in which I've excused/defended domestic abuse? lol 1
A lot of people also believe that she admitted to have faked wounds with make up . Are you one of those? 1
Great stuff. What's your opinion on the misleading headline in this case? 1
See, the funny thing is that you and some other people have here is that you assume that everyone who questions the validity of a headline has a certain agenda and then you get personal, some imply that I'm defending domestic violence others think that I'm Aquaman himself or whatever. None of that matters. :-)\n\nI'm not a fan of the term "fake news", but I do believe that headlines should be accurate and that the content delivers what that headline promises. You will find several replies within this topic that are based on the assumption that Amber Heard admitted to faking bruises/wounds with make-up, as promised by the title - but it never did happen, you might want to watch the video. It may be an unpopular and uncomfortable topic to point out the shittyness of lying headlines but still, I think that truth always should be the priority and I hate political correctness. And for the extra slow people among us - demanding truth does not imply taking any sides. The personal implications that you're making here are totally hilarious, I'm hurt, I'm strange, I'm weird and everything - funny to think about it, I read the topic of a reddit title and expected to find the content to confirm that topic. It did not do that, in fact the content proved that the headline was false. Now I'm strange and weird for discovering that? lol 1
Yes, you've already made very clear that you have no problem with people lying at you. I guess it just depends on who it is that's spreading the lies. lol 1
..
Would you be willing to acknowledge that the title of the video is a complete lie? 1
I have no doubt that you feel that way. \n\n\nAgain - I simply asked for you to establish the headline's premise based on the following video and you weren't able to do so. Just keeping track of the truth :-) 1
the hard evidence is this thread, the headline and the according video, which kind of doesn't really confirm the headline. lol 1
You're reading an awful lot of stuff into my posts for your own convenience, it's ok I can understand that in a way. I will be the first to apologize as soon as you can tell me where in the video she admits that her wounds were fake-up. That would have been a massive oversight on my end and subsequently completely irresponsible of me to spread wrong "facts". Thanks for your patience and help with this issue in advance :-) . 1
You've spent 3 days with hollow replies and ad hominem attacks (to be fair, they were somewhat poor - a "you're stupid" is pretty pathetic, IMHO). I meanwhile am just pointing out that facts should be recognized - even if someone like yourself finds them inconvenient.\n\nThe topic has been that people based their posts and opinions on a fact that "Amber Heard admitted on video that she faked wounds with makeup" - and that simply never happened so those posts and opinions have no ground. Now if they'd choose other evidence to base their comments on, I'm the first to listen to them and take them serious but lies don't help here.\n\nAgain, it's telling that people like yourself don't care about being lied at as long as it suits the agenda. Insisting on truth in reporting does not mean automatic dismissal of any other evidence, facts or information. And luckily most people view it this way as well otherwise we'd be a society that's led by headlines only and I've pointed towards the dangers of that kind of thinking several posts ago.\n\nYour dull accusations of me supporting domestic abusers are meaningless as you've proven several times that you cannot be taken seriously on any level. At least you're not a complete idiot and somehow did realize on the way that I was completely correct with my comment on the lie in the headline, so now a broader accusation has to take place. 1
Name: text, Length: 80, dtype: int64
df_audio2_comments[df_audio2_comments.author == 'controlandr3sistanc3']
df_users.query(" user_name in ['controlandr3sistanc3']")
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 68053 | controlandr3sistanc3 | True | True | True | True | NaN | NaN | NaT | banned | banned |
df_lost = df.query(" submission_text == 'and_he_lost_his_job_after_all_of_this_fuck_amber' & \
submission_comment == 'submission' ")
print(df_lost.shape)
with pd.option_context('display.max_colwidth', None):
display(df_lost.head(1))
(5, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72999 | t3_hkp7lo | /r/awfuleverything/comments/hkp7lo/and_he_lost_his_job_after_all_of_this_fuck_amber/ | And he lost his job after all of this. Fuck Amber Heard. | NaN | r/awfuleverything | -banned- | 2020-07-03 19:22:46 | Negative | Negative | 94875.0 | NaN | submission | 12 | and_he_lost_his_job_after_all_of_this_fuck_amber | 11 | [] | 0 |
df_lost.author.values
array(['-banned-', 'beanzzzzzzzzzss', 'koppleberg', 'Ford456fgfd',
'Ford456fgfd'], dtype=object)
df_lost.permalink.head(10).values
array(['/r/awfuleverything/comments/hkp7lo/and_he_lost_his_job_after_all_of_this_fuck_amber/',
'/r/RuinedMyDay/comments/hkr7ej/and_he_lost_his_job_after_all_of_this_fuck_amber/',
'/r/AnimalTextGifs/comments/hktj24/and_he_lost_his_job_after_all_of_this_fuck_amber/',
'/r/awfuleverything/comments/hkuqbh/and_he_lost_his_job_after_all_of_this_fuck_amber/',
'/r/awfuleverything/comments/hkxpm9/and_he_lost_his_job_after_all_of_this_fuck_amber/'],
dtype=object)
it sensitive content related to cutting his finger
5 different submissions
df_lost_comments = df.query(" submission_text == 'and_he_lost_his_job_after_all_of_this_fuck_amber' ")
print(df_lost_comments.shape)
df_lost_comments.head()
(3568, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72999 | t3_hkp7lo | /r/awfuleverything/comments/hkp7lo/and_he_lost... | And he lost his job after all of this. Fuck Am... | NaN | r/awfuleverything | -banned- | 2020-07-03 19:22:46 | Negative | Negative | 94875.0 | NaN | submission | 12 | and_he_lost_his_job_after_all_of_this_fuck_amber | 11 | [] | 0 |
| 73000 | t1_fwu153c | /r/awfuleverything/comments/hkp7lo/and_he_lost... | Is this for real? \n\nIf so wtf, psycho bitch,... | t3_hkp7lo | r/awfuleverything | MrBreaker187 | 2020-07-03 19:30:01 | Negative | Negative | 4464.0 | submission | comment | 14 | and_he_lost_his_job_after_all_of_this_fuck_amber | 11 | [] | 0 |
| 73001 | t1_fwu24gd | /r/awfuleverything/comments/hkp7lo/and_he_lost... | Belive so, but she has been taken off the set ... | t1_fwu153c | r/awfuleverything | Fleischer021 | 2020-07-03 19:38:55 | Neutral | Neutral | 1626.0 | comment | comment | 13 | and_he_lost_his_job_after_all_of_this_fuck_amber | 11 | [] | 0 |
| 73002 | t1_fwu251t | /r/awfuleverything/comments/hkp7lo/and_he_lost... | This is for real. She’s a psycho. He’s amazing... | t3_hkp7lo | r/awfuleverything | squidlygreen | 2020-07-03 19:39:04 | Positive | Neutral | 92.0 | submission | comment | 35 | and_he_lost_his_job_after_all_of_this_fuck_amber | 11 | [] | 0 |
| 73003 | t1_fwu26tf | /r/awfuleverything/comments/hkp7lo/and_he_lost... | Yes, it’s for real (at least directionally, ha... | t1_fwu153c | r/awfuleverything | Monkey___Boy | 2020-07-03 19:39:31 | Negative | Positive | 114.0 | comment | comment | 23 | and_he_lost_his_job_after_all_of_this_fuck_amber | 11 | [] | 0 |
df_lost_contributions = df_lost_comments.groupby(df_lost_comments.created_at.dt.date).size().reset_index(name='n_contributions')
fig = px.bar(df_lost_contributions.head(),
x='created_at',
y='n_contributions', title='The number of contributions/date on these submissions')
fig.update_layout(
xaxis = dict(
title='Contribution Date',
tickmode = 'array',
tickvals = df_lost_contributions.head().created_at,
)
)
clrs = ['red' if (y > 200) else '#5296dd' for y in df_lost_contributions.n_contributions]
fig.update_traces(marker_color=clrs, marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
those contributions were in 3 and 4 july *=(finger cut off)
df_lost_authors = df_lost_comments.groupby(df_lost_comments.author).size().reset_index(name='n_contributions')
fig = px.bar(df_lost_authors,
x='author',
y='n_contributions', title='The number of contributions per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.3, textposition='auto')
# , marker_line_color='#5296dd', marker_line_width=2
fig.update_yaxes(range = [0,25])
fig.show()
Invesigating the sumbissions with most comments
(Top Level Comments)
df.parent_id.value_counts().head()
t3_eyp2d3 1695 t3_f0q0ao 1203 t3_kdznjp 940 t3_hkp7lo 831 t3_fwf5kv 479 Name: parent_id, dtype: int64
fig = px.bar(df.parent_id.value_counts().to_frame().head(25).reset_index(), x="parent_id", y="index",
height=500,
title='sumbissions with most comments (Top Level Comments)').update_layout(
xaxis_title='Number of comments',
yaxis_title='subbredit').update_traces(marker_color='#5296dd')
fig.update_yaxes(autorange="reversed")
df_top5 = df_merged[df_merged.child_id.isin(df_merged.parent_id.value_counts().head().index)]
with pd.option_context('display.max_colwidth', None):
display(df_top5)
| child_id | permalink | text | parent_id | subreddit | created_at | sentiment_blob | sentiment_nltk | score | top_level | ... | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | diff | days_after_creation | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10955 | t3_hkp7lo | /r/awfuleverything/comments/hkp7lo/and_he_lost_his_job_after_all_of_this_fuck_amber/ | And he lost his job after all of this. Fuck Amber Heard. | NaN | r/awfuleverything | 2020-07-03 19:22:46 | Negative | Negative | 94875.0 | NaN | ... | False | False | False | 77234.0 | 82.0 | 2011-11-06 21:08:20 | others | others | 3161 days 22:14:26 | 3161.0 |
| 36944 | t3_eyp2d3 | /r/videos/comments/eyp2d3/audio_of_amber_heard_admitting_she_was_the_one/ | Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp. | NaN | r/videos | 2020-02-04 12:04:19 | Neutral | Negative | 98525.0 | NaN | ... | False | False | False | 157950.0 | 92848.0 | 2019-07-27 01:15:02 | others | 2019 | 192 days 10:49:17 | 192.0 |
| 55444 | t3_fwf5kv | /r/entertainment/comments/fwf5kv/amber_heard_could_face_3_years_of_imprisonment_if/ | Amber Heard Could Face 3 Years Of Imprisonment If Found Guilty Of Faking Evidence | NaN | r/entertainment | 2020-04-07 06:00:01 | Negative | Negative | 38903.0 | NaN | ... | True | True | False | 54893.0 | 308711.0 | 2018-11-17 20:34:39 | unverified | 2018 | 506 days 09:25:22 | 506.0 |
| 58190 | t3_f0q0ao | /r/videos/comments/f0q0ao/johnny_depp_amber_heard_new_unsensored_audio/ | Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof. | NaN | r/videos | 2020-02-08 10:39:34 | Positive | Positive | 81052.0 | NaN | ... | True | False | False | 24276.0 | 95091.0 | 2014-04-05 13:36:07 | others | others | 2134 days 21:03:27 | 2134.0 |
| 124266 | t3_kdznjp | /r/awfuleverything/comments/kdznjp/amber_heard_hired_for_33000_per_talk_in_domestic/ | Amber Heard hired for $33,000 per talk in domestic abuse, despite evidence suggesting she herself is a domestic abuser. | NaN | r/awfuleverything | 2020-12-16 01:48:45 | Neutral | Negative | 64967.0 | NaN | ... | False | False | False | 3243.0 | 14068.0 | 2019-09-17 12:11:58 | others | 2019 | 455 days 13:36:47 | 455.0 |
5 rows × 24 columns
df_merged.submission_text = df_merged.submission_text.str.replace('_', ' ')
# get a list with the top 5 submission text
top5_text = list(df_top5.text)
top5_text
['And he lost his job after all of this. Fuck Amber Heard.', 'Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp.', 'Amber Heard Could Face 3 Years Of Imprisonment If Found Guilty Of Faking Evidence', 'Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof.', 'Amber Heard hired for $33,000 per talk in domestic abuse, despite evidence suggesting she herself is a domestic abuser.']
for i in top5_text:
print('- ',i)
- And he lost his job after all of this. Fuck Amber Heard. - Audio of Amber Heard admitting she was the one who was abusive towards Johnny Depp. - Amber Heard Could Face 3 Years Of Imprisonment If Found Guilty Of Faking Evidence - Johnny Depp & Amber Heard: NEW Unsensored Audio - Amber tells Depp nobody will believe him, and also admit to drawing wounds on erself with makeup and taking pictures of them for proof. - Amber Heard hired for $33,000 per talk in domestic abuse, despite evidence suggesting she herself is a domestic abuser.
def compare(str):
for text in top5_text:
if str in text:
return True
else: return False
mask = df_merged.submission_text.apply(compare)
df_top5_contributions1 = df_merged[mask]
df_top5_authors = df_top5_contributions1.groupby(df_top5_contributions1.user_name).size().reset_index(name='n_contributions')
fig = px.bar(df_top5_authors,
x='user_name',
y='n_contributions', title='The number comments per author on these submissions')
fig.update_traces(marker_color='#5296dd', opacity=1, textposition='auto')
fig.show()
df_top5_contributions1.shape
(75, 24)
df_top5_contributions2 = df_merged[df_merged.parent_id.isin(df_merged.parent_id.value_counts().head().index)]
df_top5_authors = df_top5_contributions2.groupby(df_top5_contributions2.user_name).size().reset_index(name='n_contributions')
fig = px.bar(df_top5_authors,
x='user_name',
y='n_contributions', title='The number of parent comments per author on these submissions')
fig.update_traces(marker_line_color='#5296dd', marker_line_width=0.3, textposition='auto')
# , marker_line_color='#5296dd', marker_line_width=2
fig.update_yaxes(range = [0,5])
fig.show()
df_top5_contributions2.shape
(5148, 24)
Invesigating authors with the most submissions¶
df_submissions = df[df.submission_comment == 'submission']
print(df_submissions.shape)
df_submissions.head(2)
(7883, 17)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | t3_eimt8q | /r/ladyladyboners/comments/eimt8q/amber_heard/ | Amber Heard | NaN | r/ladyladyboners | -banned- | 2020-01-01 19:53:43 | Neutral | Neutral | 11.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
| 5 | t3_eioopj | /r/celebnsfw/comments/eioopj/amber_heard/ | Amber Heard | NaN | r/celebnsfw | knightfall1993 | 2020-01-01 22:14:03 | Neutral | Neutral | 202.0 | NaN | submission | 2 | amber_heard | 2 | [] | 0 |
df_submissions.author.value_counts().nlargest(n=10)
-banned- 2571 Support_Johnny_Depp 250 DerHander 218 AutoNewsAdmin 105 toutfilm 95 AutoNewspaperAdmin 71 newsfeedmedia 62 MetiNews 58 CelebBattleVoteBot 49 -en- 49 Name: author, dtype: int64
df_submissions.author.value_counts().to_frame().head(10)
| author | |
|---|---|
| -banned- | 2571 |
| Support_Johnny_Depp | 250 |
| DerHander | 218 |
| AutoNewsAdmin | 105 |
| toutfilm | 95 |
| AutoNewspaperAdmin | 71 |
| newsfeedmedia | 62 |
| MetiNews | 58 |
| CelebBattleVoteBot | 49 |
| -en- | 49 |
fig = px.bar(df_submissions.author.value_counts().to_frame().head(10).reset_index(), x="author", y="index",
height=500,
title='Authors with most Submissions').update_traces(marker_color='#5296dd',).update_layout(
xaxis_title='Number of Negative Submissions',
yaxis_title='Author_Name').update_traces(marker_color='#5296dd')
fig.update_yaxes(autorange="reversed")
Check wether the users with the most submissions are mod, gold or having a verified email¶
df_submissions.author.value_counts().head()
-banned- 2571 Support_Johnny_Depp 250 DerHander 218 AutoNewsAdmin 105 toutfilm 95 Name: author, dtype: int64
check_list = df_submissions.author.value_counts().nlargest(n=25).index.tolist()[1:]
check_list
['Support_Johnny_Depp', 'DerHander', 'AutoNewsAdmin', 'toutfilm', 'AutoNewspaperAdmin', 'newsfeedmedia', 'MetiNews', 'CelebBattleVoteBot', '-en-', 'internewscast', 'cdroid7', 'iDevice_Help', 'TrialTheLegend', 'TheAndredal', 'the-speed-of-pain', 'distinctathlete', 'UKNewsByABot', 'templederr', 'Dannig178', 'Bot-alex', 'removalbot', 'rodrigohernandez4477', 'feedimo', 'motivatornetwork']
# get a data frame with the most negative-comments users
df_check = df_users[df_users['user_name'].isin(check_list)]
print(df_check.shape)
df_check.head(2)
(24, 10)
| user_name | has_verified_email | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | |
|---|---|---|---|---|---|---|---|---|---|---|
| 13888 | Dannig178 | True | True | True | False | 2765.0 | 982410.0 | 2014-05-14 14:35:40 | others | others |
| 16745 | TheAndredal | True | True | True | False | 52848.0 | 1870964.0 | 2015-01-10 04:20:02 | others | others |
df_check['user_name'].nunique()
24
for col in df_check.columns:
if col not in ['user_name', 'user_created_at']:
print('The value counts of the users with the most submissions: ' + col)
print(df_check[col].value_counts())
print('\n')
The value counts of the users with the most submissions: has_verified_email True 23 False 1 Name: has_verified_email, dtype: int64 The value counts of the users with the most submissions: is_mod True 22 False 2 Name: is_mod, dtype: int64 The value counts of the users with the most submissions: is_gold False 15 True 9 Name: is_gold, dtype: int64 The value counts of the users with the most submissions: is_banned False 18 True 6 Name: is_banned, dtype: int64 The value counts of the users with the most submissions: comment_karma 0.0 3 12647.0 1 2.0 1 55.0 1 1063.0 1 13.0 1 2765.0 1 40.0 1 1370.0 1 -10.0 1 73.0 1 22.0 1 26.0 1 10.0 1 52848.0 1 1.0 1 Name: comment_karma, dtype: int64 The value counts of the users with the most submissions: link_karma 245787.0 1 1870964.0 1 328.0 1 8374.0 1 2.0 1 249122.0 1 681.0 1 982410.0 1 6772.0 1 2012.0 1 20936.0 1 2629.0 1 5113.0 1 125906.0 1 20315.0 1 366459.0 1 2210.0 1 15865.0 1 Name: link_karma, dtype: int64 The value counts of the users with the most submissions: banned_unverified others 17 banned 6 unverified 1 Name: banned_unverified, dtype: int64 The value counts of the users with the most submissions: creation_year others 10 banned 6 2019 3 2018 3 2020 2 Name: creation_year, dtype: int64
df_check.comment_karma.min(), df_check.comment_karma.max()
(-10.0, 52848.0)
df_check.comment_karma.mean(), df_check.comment_karma.median()
(3940.277777777778, 24.0)
df_check.link_karma.min(), df_check.link_karma.max()
(2.0, 1870964.0)
df_check.link_karma.mean(), df_check.link_karma.median()
(218104.72222222222, 12119.5)
df['urls'].nunique()
1086
df[df.astype(str)['urls'] != '[]'].head(2)
| child_id | permalink | text | parent_id | subreddit | author | created_at | sentiment_blob | sentiment_nltk | score | top_level | submission_comment | text_words | submission_text | submission_words | urls | urls_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | t1_fcxq6c4 | /r/Celebhub/comments/ejhpv4/amber_heard/fcxq6c4/ | Make sure to follow our community guidelines.\... | t3_ejhpv4 | r/Celebhub | AutoModerator | 2020-01-03 16:27:21 | Positive | Positive | 1.0 | submission | comment | 44 | amber_heard | 2 | ['https://redd.it', 'https://www.instagram.com'] | 2 |
| 24 | t1_fczhjef | /r/JerkOffToCelebs/comments/ejpdwr/amber_heard... | **Thank you for your submission. Make sure to ... | t3_ejpdwr | r/JerkOffToCelebs | AutoModerator | 2020-01-04 01:29:49 | Positive | Positive | 1.0 | submission | comment | 52 | amber_heard_nipple_pokies_in_a_white_tank_top | 9 | ['https://jerkofftocelebs.com', 'https://www.i... | 3 |
df['urls'].astype('str').value_counts().head()
[] 123195 ['https://www.reddit.com'] 470 ['https://youtu.be'] 342 ['https://www.youtube.com'] 197 ['http://chng.it'] 190 Name: urls, dtype: int64
# the value counts of the # of urls
df['urls_count'].value_counts();
fig = px.histogram(df['urls_count'].to_frame(), x="urls_count",title='Count of the number of URLS in each Contribution',
nbins=130).update_traces(marker_color='#5296dd')
fig.update_layout(
xaxis = dict(
tickmode = 'array',
tickvals = df['urls_count'],
)
)
fig.show()
px.histogram(df[~(df['urls_count'].isin([0,60,20,16]))], x="urls_count",title='Count of the number of URLS in each Contribution',
nbins=20).update_traces(marker_color='#5296dd')
Check the number of submission text words
Of course few words are easier for bots to create
fig = px.histogram(df['submission_words'].to_frame(), x="submission_words",
title='number of words in submission text',
nbins=50).update_traces(marker_color='#5296dd')
fig.update_layout(
xaxis = dict(
title='Number of submission words',
tickmode = 'linear',
)
)
Most used Subreddits¶
df['subreddit'].nunique()
1164
df['subreddit'] = df['subreddit'].str[:]
df.subreddit.value_counts().to_frame().head(10).reset_index()
| index | subreddit | |
|---|---|---|
| 0 | r/videos | 24955 |
| 1 | r/entertainment | 8945 |
| 2 | r/MensRights | 8087 |
| 3 | r/pussypassdenied | 6589 |
| 4 | r/awfuleverything | 6563 |
| 5 | r/memes | 5181 |
| 6 | r/iamatotalpieceofshit | 4757 |
| 7 | r/AskReddit | 2898 |
| 8 | r/unpopularopinion | 2741 |
| 9 | r/TrueOffMyChest | 2378 |
fig = px.bar(df.subreddit.value_counts().to_frame().head(20).reset_index(), x="subreddit", y="index",
height=500,
title='Most used subbredits').update_traces(marker_color='#5296dd',).update_layout(
xaxis_title='Number of comments',
yaxis_title='subbredit').update_traces(marker_color='#5296dd')
fig.update_yaxes(autorange="reversed")
Merged Users Data with Comments & Submissions Data¶
Difference in time between creating the account and posting¶
# note that value_counts() neglect Zeros
df_merged["days_after_creation"].value_counts()
3011.0 1277
3009.0 862
3015.0 838
3014.0 719
3013.0 708
...
4505.0 1
4939.0 1
4542.0 1
4503.0 1
4539.0 1
Name: days_after_creation, Length: 4386, dtype: int64
px.histogram(df_merged, x="days_after_creation",title='days_after_creation',
nbins=250).update_traces(marker_color='#5296dd',).update_layout(
xaxis_title='number of days',)
print('The number of accounts posted the same day they was created!')
df_merged[df_merged['days_after_creation'] == 0].shape[0]
The number of accounts posted the same day they was created!
360
print('The number of accounts posted the same week they was created!')
df_merged[df_merged['days_after_creation'] <= 7].shape[0]
The number of accounts posted the same week they was created!
1209
print('The number of accounts posted the same month they was created!')
df_merged[df_merged['days_after_creation'] <= 30].shape[0]
The number of accounts posted the same month they was created!
3146
df_merged[df_merged['days_after_creation'] <= 30]['user_created_at'].dt.year.value_counts()
2020 3139 2019 7 Name: user_created_at, dtype: int64
we can find that 3139 accounts created and posted within the same month in 2020.
mask = (df_merged['days_after_creation'] <= 30) & (df_merged['user_created_at'].dt.year == 2020)
df_merged[mask]['user_created_at'].dt.strftime('%b').value_counts()
Jan 611 Nov 573 Oct 325 Feb 299 Mar 267 Apr 251 Dec 204 Jun 196 Jul 172 Aug 114 May 75 Sep 52 Name: user_created_at, dtype: int64
months = df_merged[df_merged['days_after_creation'] <= 30]['user_created_at'].dt.strftime('%b')
months_sorted = months.value_counts()
months_sorted
Jan 611 Nov 573 Oct 325 Feb 299 Mar 267 Apr 251 Dec 211 Jun 196 Jul 172 Aug 114 May 75 Sep 52 Name: user_created_at, dtype: int64
months_sorted.to_frame().reset_index().rename(columns={'index':'Month',
'user_created_at': 'n_contributions'})
| Month | n_contributions | |
|---|---|---|
| 0 | Jan | 611 |
| 1 | Nov | 573 |
| 2 | Oct | 325 |
| 3 | Feb | 299 |
| 4 | Mar | 267 |
| 5 | Apr | 251 |
| 6 | Dec | 211 |
| 7 | Jun | 196 |
| 8 | Jul | 172 |
| 9 | Aug | 114 |
| 10 | May | 75 |
| 11 | Sep | 52 |
fig = px.bar(months_sorted.to_frame().reset_index().rename(columns={'index':'Month',
'user_created_at': 'n_contributions'}),
x='Month', y='n_contributions', text='n_contributions')
fig.update_layout(
title={
'text': "contributions of the accounts posted/commented <br> the same month they were created",
'x':0.5,
'xanchor': 'center',
'yanchor': 'top'
})
# fig.update_layout(
# xaxis = dict(
# title='Month(2021)',
# tickmode = 'array',
# tickvals = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
# ticktext = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
# )
# )
clrs = ['red' if (y > 100) else '#5296dd' for y in months_sorted.values]
fig.update_traces(marker_color=clrs,
marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
# months_sorted.plot(kind='bar', figsize=(8,8), title='contributions of the accounts posted/commented \n the same month they were created');
# THE SAME MONTH:
# check for the date these accounts posted/commented
reddit_30 = df_merged[df_merged['days_after_creation'] <= 30]
dates_count = df_merged.groupby(reddit_30['created_at'].dt.date).size().reset_index(name='contributions')
dates_count.sort_values('contributions', ascending=False);
fig = px.bar(dates_count,
x='created_at',
y='contributions', title = 'contributions of the accounts posted/commented the same month they were created')
fig.show()
# THE SAME WEEK
# check for the date these accounts posted/commented
reddit_7 = df_merged[df_merged['days_after_creation'] <= 7]
dates_count_7 = df_merged.groupby(reddit_7['created_at'].dt.date).size().reset_index(name='contributions')
dates_count_7.sort_values('contributions', ascending=False);
fig = px.bar(dates_count_7,
x='created_at',
y='contributions', title = 'contributions of the accounts posted/commented the same week they were created')
fig.show()
# THE SAME DAY
# check for the date these accounts posted/commented
reddit_1 = df_merged[df_merged['days_after_creation'] <= 0]
dates_count_1 = df_merged.groupby(reddit_1['created_at'].dt.date).size().reset_index(name='contributions')
dates_count_1.sort_values('contributions', ascending=False);
fig = px.bar(dates_count_1,
x='created_at',
y='contributions', title = 'contributions of the accounts posted/commented the same day they were created')
fig.show()
# get the author names that commented in a negative way the same month the account was created
# to add to the suspected list
df_merged_30 = df_merged.query("days_after_creation <= 30 & sentiment_blob == sentiment_nltk == 'Negative' ")
df_merged_30.head()
| child_id | permalink | text | parent_id | subreddit | created_at | sentiment_blob | sentiment_nltk | score | top_level | ... | is_mod | is_gold | is_banned | comment_karma | link_karma | user_created_at | banned_unverified | creation_year | diff | days_after_creation | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19508 | t1_fddl7cr | /r/MensRights/comments/eknahg/petition_to_remo... | I mean do you even know the facts, your as bad... | t1_fddkzb6 | r/MensRights | 2020-01-06 13:15:14 | Negative | Negative | -5.0 | comment | ... | False | False | False | 7090.0 | 4634.0 | 2019-12-26 21:14:04 | unverified | 2019 | 10 days 16:01:10 | 10.0 |
| 20226 | t1_fel3xah | /r/JerkOffToCelebs/comments/epqpa1/would_you_r... | I'm between option 1 or 4. Hard to choose | t3_epqpa1 | r/JerkOffToCelebs | 2020-01-16 22:25:25 | Negative | Negative | 2.0 | submission | ... | False | False | False | 507.0 | 11083.0 | 2019-12-19 15:16:23 | others | 2019 | 28 days 07:09:02 | 28.0 |
| 20260 | t1_fh4v3sx | /r/entertainment/comments/f14uop/e_news_makes_... | I sent them a scathing message about this doub... | t3_f14uop | r/entertainment | 2020-02-09 21:05:52 | Negative | Negative | 2.0 | submission | ... | False | False | False | 2.0 | 1.0 | 2020-01-18 01:31:31 | others | 2020 | 22 days 19:34:21 | 22.0 |
| 20589 | t1_fgeex74 | /r/ladyladyboners/comments/etafq5/amber_heard_... | Hey! You were right! My bad! | t1_fffcb9h | r/ladyladyboners | 2020-02-03 02:46:25 | Negative | Negative | 2.0 | comment | ... | False | False | False | 1304.0 | 5756.0 | 2020-01-20 14:25:42 | unverified | 2020 | 13 days 12:20:43 | 13.0 |
| 21904 | t1_fgj3wb4 | /r/videos/comments/eyp2d3/audio_of_amber_heard... | Idk why you are getting downvoted. The women w... | t1_fgilx90 | r/videos | 2020-02-04 17:14:59 | Negative | Negative | 4.0 | comment | ... | False | False | False | 8271.0 | 89.0 | 2020-01-08 11:43:55 | unverified | 2020 | 27 days 05:31:04 | 27.0 |
5 rows × 24 columns
Estimation of Number of User Accounts Created in each year / having contributions in 2020¶
# group by creation year and count
df_contributions = df_merged.groupby(df_merged['user_created_at'].dt.year).size().reset_index(name='n_accounts')
fig = px.bar(df_contributions,
x='user_created_at', y='n_accounts', text='n_accounts', title='Number of User Accounts Created in each year / having contributions in 2020')
fig.update_traces(marker_color='#5296dd',
marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
Contributions count over Months in 2020¶
fig = px.bar(df.groupby(df['created_at'].dt.month).size().reset_index(name='contribution_count'),
x='created_at', y='contribution_count', text='contribution_count')
fig.update_layout(
title={
'text': "Estimation of the number contributions created in each month of 2020",
'x':0.5,
'xanchor': 'center',
'yanchor': 'top'
})
fig.update_layout(
xaxis = dict(
title='Month(2020)',
tickmode = 'array',
tickvals = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
ticktext = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
)
)
clrs = ['red' if (y > 4000) else '#5296dd' for y in df.groupby(df['created_at'].dt.month).size()]
fig.update_traces(marker_color=clrs,
marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
Contributions count over Days of month in 2020¶
fig = px.bar(df.groupby(df['created_at'].dt.day).size().reset_index(name='contribution_count'),
x='created_at', y='contribution_count', text='contribution_count')
fig.update_layout(
title={
'text': "Estimation of the number contributions created in each DayOfMonth in 2020",
'x':0.5,
'xanchor': 'center',
'yanchor': 'top'
})
fig.update_layout(
xaxis = dict(
title='Month Days(2021)',
tickmode = 'linear',
)
)
clrs = ['red' if (y > 1500) else '#5296dd' for y in df.groupby(df['created_at'].dt.day).size()]
fig.update_traces(marker_color=clrs,
marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
In Which DayOfWeek users created more?¶
week_day = df['created_at'].dt.strftime('%a')
# one can sort by any order by providing a custom index explicitely :
# https://stackoverflow.com/questions/43855474/changing-sort-in-value-counts/43855492
week_sorted = week_day.value_counts()[['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']]
week_sorted
Mon 15078 Tue 22109 Wed 19155 Thu 13680 Fri 14862 Sat 22322 Sun 21202 Name: created_at, dtype: int64
fig = px.bar(df.groupby(df['created_at'].dt.dayofweek).size().reset_index(name='contribution_count'),
x='created_at', y='contribution_count', text='contribution_count')
fig.update_layout(
title={
'text': "Estimation of the number contributions created in each DayOfWeek (2020)",
'x':0.5,
'xanchor': 'center',
'yanchor': 'top'
})
fig.update_layout(
xaxis = dict(
title='DayOfWeek(2020)',
tickmode = 'array',
tickvals = [0, 1, 2, 3, 4, 5, 6],
ticktext = ['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']
)
)
clrs = ['red' if (y > 4000) else '#5296dd' for y in df.groupby(df['created_at'].dt.dayofweek).size()]
fig.update_traces(marker_color=clrs,
marker_line_width=1.5, opacity=1, textposition='auto')
fig.show()
check for the hour the contributions were made (2020)¶
# check for the hour the contributions were made
df_hours = df.groupby(df['created_at'].dt.hour).size().reset_index(name='contribution_count')
# df_hours.sort_values('contribution_count', ascending=False);
fig = px.bar(df_hours,
x='created_at', y='contribution_count',
title='Number of contrbutions Comment/Submission in day hours (2020)')
fig.update_layout(
xaxis = dict(
title='Hours of Day',
tickmode = 'linear',
dtick = 1
)
)
fig.update_traces(marker_color='#5296dd',
marker_line_width=1.5, opacity=1, textposition='auto').update_layout()
fig.show()
It's weird to have high contributions all the day!!
Which dates has the highest contrbitions for users?¶
df.created_at.dt.date.value_counts().head(20)
2020-02-04 9630 2020-02-08 6540 2020-02-02 6138 2020-11-07 5852 2020-02-07 4618 2020-02-05 4473 2020-02-09 4289 2020-12-16 3444 2020-02-06 3182 2020-02-03 3177 2020-11-08 3106 2020-05-04 2780 2020-04-07 2626 2020-07-04 2174 2020-04-09 1406 2020-11-09 1315 2020-07-03 1309 2020-04-08 1291 2020-02-10 1241 2020-11-13 1235 Name: created_at, dtype: int64
trendy_dates = df.groupby(df['created_at'].dt.date).size().reset_index(name='contribution_count')
fig = px.bar(trendy_dates,
x='created_at', y='contribution_count')
fig.update_layout(
title={
'text': "The number of contributions created in each date",
'x':0.5,
'xanchor': 'center',
'yanchor': 'top'
})
fig.show()
trendy_dates.sort_values('contribution_count', ascending=False)
| created_at | contribution_count | |
|---|---|---|
| 34 | 2020-02-04 | 9630 |
| 38 | 2020-02-08 | 6540 |
| 32 | 2020-02-02 | 6138 |
| 311 | 2020-11-07 | 5852 |
| 37 | 2020-02-07 | 4618 |
| ... | ... | ... |
| 157 | 2020-06-06 | 6 |
| 0 | 2020-01-01 | 6 |
| 4 | 2020-01-05 | 5 |
| 22 | 2020-01-23 | 4 |
| 1 | 2020-01-02 | 3 |
366 rows × 2 columns
# get the top 5 trendy dates first, then sort them by date
top_trendy_dates = trendy_dates.sort_values('contribution_count', ascending=False).head(5)
top_trendy_dates.sort_values('contribution_count', inplace=True)
top_trendy_dates
| created_at | contribution_count | |
|---|---|---|
| 37 | 2020-02-07 | 4618 |
| 311 | 2020-11-07 | 5852 |
| 32 | 2020-02-02 | 6138 |
| 38 | 2020-02-08 | 6540 |
| 34 | 2020-02-04 | 9630 |
top_trendy_dates.reset_index(inplace=True)
fig = px.bar(top_trendy_dates,
x='created_at', y='contribution_count', title='Number of contrbutions Comment/Submission in trendy dates')
fig.update_layout(
xaxis = dict(
title='Contribution Date',
tickmode = 'array',
tickvals = top_trendy_dates.created_at,
)
)
clrs = ['red' if (y > 400) else '#5296dd' for y in top_trendy_dates.contribution_count]
fig.update_traces(marker_color=clrs,
opacity=1, textposition='auto').update_layout()
# marker_line_width=1.5,
fig.show()
def peack_days(date):
print(f'How many users contributed on the peak day ({date})')
print(df_merged[df_merged.created_at.dt.strftime('%Y-%m-%d') == date].user_name.nunique())
print('Years')
df_merged_peak1 = df_merged[df_merged.created_at.dt.strftime('%Y-%m-%d') == date]
# check for the year the accounts were created
df_user_year1 = df_merged_peak1.groupby(df_merged_peak1['user_created_at'].dt.year).size().reset_index(name='contribution_count')
fig = px.bar(df_user_year1,
x='user_created_at', y='contribution_count',
title=f'The creation year of the accounts contributed on the peak day ({date})')
fig.update_layout(
xaxis = dict(
title='Accout Creation Year',
tickmode = 'linear',
dtick = 1
)
)
clrs = ['red' if (y > 250) else '#5296dd' for y in df_user_year1.contribution_count]
fig.update_traces(marker_color=clrs,
marker_line_width=1.5, opacity=1, textposition='auto').update_layout()
fig.show()
print('hours')
df_peak_1 = df[df.created_at.dt.strftime('%Y-%m-%d') == f'{date}']
# check for the hour the contributions were made
df_hours = df_peak_1.groupby(df['created_at'].dt.hour).size().reset_index(name='contribution_count')
# df_hours.sort_values('contribution_count', ascending=False);
fig2 = px.bar(df_hours,
x='created_at', y='contribution_count',
title='Number of contrbutions Comment/Submission in day hours')
fig2.update_layout(
xaxis = dict(
title='Hours of Day',
tickmode = 'linear',
dtick = 1
)
)
clrs = ['red' if (y > 80) else '#5296dd' for y in df_hours.contribution_count]
fig2.update_traces(marker_color=clrs,
marker_line_width=1.5, opacity=1, textposition='auto').update_layout()
fig2.show()
a = list(top_trendy_dates.created_at.values)
a.sort()
for date in a:
print(date)
2020-02-02 2020-02-04 2020-02-07 2020-02-08 2020-11-07
peack_days('2020-02-02')
How many users contributed on the peak day (2020-02-02) 3145 Years
hours
peack_days('2020-02-04')
How many users contributed on the peak day (2020-02-04) 4752 Years
hours
peack_days('2020-02-02')
How many users contributed on the peak day (2020-02-02) 3145 Years
hours
peack_days('2020-02-07')
How many users contributed on the peak day (2020-02-07) 2395 Years
hours
peack_days('2020-05-19')
How many users contributed on the peak day (2020-05-19) 180 Years
hours
peack_days('2020-07-04')
How many users contributed on the peak day (2020-07-04) 1363 Years
hours
peack_days('2020-02-07')
How many users contributed on the peak day (2020-02-07) 2395 Years
hours